Running Totals

[dbware]

I have a report where a group is suppressed bases on the running total. This works fine.

What I am having a problem with is that I also need an additional running Total Field at the end of the report where it will total all running totals from the unsuppressed groups.

group not displayed
pn loc total
1 1 10.00
1 2 30.00
total 40.00

group displayed
pn loc total
2 1 10.00
2 2 20.00
total 30.00

group displayed
pn loc total
3 1 5.00
3 2 10.00
total 15.00

I would like the report to report the following:
report footer
total 45.00

What the report is doing today is this:
report footer
total 85.00


Thank you,


Mauro

 

[synapsevampire]

Create a Running Total field which does not get reset and in the evaulate use a formula, use the opposite criteria that you used to suppress the individual running totals.

If this isn't feasible, share the formula you used to conditionally suppress.

-k

 

[dbware]

Thank you Ken,

Tried it but it did not work. I cannot setup a Running total on a Running total. This is the error
-You cannot select this field as the field to summarize/reset/evaluate-

Here is suppressing formula:
if {@A-T-P}<=0 then true
else
false

Thank you

-M

 

[lbass]

What SV was suggesting is that you create a new running total that does not refer to your existing running totals. For example, let's say that your group totals were developed by selecting {table.amt}, sum, evaluate on change of {loc}, reset on change of {pn}. To get a total of these group totals (but using the data that contributed to them, not the totals themselves), create a new running total by selecting {table.amt}, sum, evaluate based on a formula like the following:

if onfirstrecord then {@A-T-P} > 0
else
if not (onfirstrecord) then {loc} <> previous {loc} and
{@A-T-P} > 0

Reset never.

This is just an example, since we don't know the specifics of your data. If you need more assistance, please provide more information, e.g., what is the formula for {@A-T-P}, is {total} a field at the detail level and a running total at the group level, etc.

-LB