sum of a running total

[katididdy]

Hi everyone.

I need to sum the amount of trucks that are overweight for a report (> 74500 lbs). I have this amount in a running total, but I am unable to sum it. I need to get the percentage of trucks overweight (overweight/total#oftrucks) for 2 different places. Does anyone have any suggestions on how I can do this? Any help is appreciated!

Thank you,
Katherine

 

[synapsevampire]

We don't know what "(overweight/total#oftrucks) for 2 different places." means, try taking the time to be specific.

Rather than use a Running total, in the details try formulas of:

//number of trucks
If {table.weight} > 74500 then
1
else
0

//total weight, not sure if you need this
If {table.weight} > 74500 then
{table.weight}
else
0

Now you can right click these formulas and use the conventional Insert->Summary->Sum to create aggregates at the group level or as grand totals.

As for getting a percentage, you can use:

sum({@MyTruckFormula})%count({table.weight})

-k

 

[katididdy]

Thank you for your help! It's working now, report has been presented.