CODEWITHSUNDEEP
crystal-reportsresetformulas
Alicia Uhacz
Alicia Uhacz

Reputation: 77

I need to reset a sum amount each time the group data is executed.

We have the sum of a formula (Sum({@EstHours})-SUM({@ActHours})) that we need to reset to zero, then calculate per phase line. The reset formula is in the same group the Balance formula aforementioned is in. I have also tried placing it in different sections. The ResetBalance formula I've been trying to use is WhilePrintingRecords; NumberVar Balance:=0;

Upvotes: 0

Views: 2336

Answers (1)

craig
craig

Reputation: 26262

Adapt this formula to your specific situation:

// {@delta}
Sum({@EstHours}, {table.groupingField}) - Sum({@ActHours, {table.groupingField})

Add field to {table.groupingField}'s group header or footer.

Upvotes: 1

Related Questions