Grand Total After Evaluating on Change of Field 1

[austin22]

Crystal 8.5

I want to calculate a grand total for all groups after evaluating on change of field. I am grouping by case number.

Example:
Group 1
50.00
50.00
75.00
75.00 = 125.00

Group 2
10.00
10.00
20.00
20.00 = 30.00

How do I display the 155.00 value instead of the duplicate totals within each group?

 

[lbass]

Looks like you were using a running total. Create another running total and this time use a formula in the evaluation section:

onfirstrecord or
{table.field} <> previous({table.field}) or //your current "on change of" field should be substituted for {table.field}
{table.groupfield} <> previous({table.groupfield})

Reset never.

-LB

 

[austin22]

AWESOME! Thank you so much. You guys are great.