Help with sum formula

[priyanthan]

I have a report with duplicate records and need to summarize few fields.

I’m using the following formula (@DisPurchase) to eliminate the duplicate records,

If Onfirstrecord or ({BNSMISRPT.TRANSEQ}) <> previous ({BNSMISRPT.TRANSEQ}) then
{@Purchase}
else 0

When i try to sum the @DisPurchase I’m not able to sum.
Working with CR 8.5 / DB2
Can anyone please help me with this.

Thanks.

 

[lbass]

You can insert a running total that does a sum of {@Purchase}, evaluate on change of field or group (if you grouped on this field): {BNSMISRPT.TRANSEQ}. Reset never or on change of some higher order group. Place in a footer section only.

-LB

 

[priyanthan]

I cannot even create a running total. i don't see the @DisPurchase in the available fields.

thanks.

 

[lbass]

No, insert a running total and use {@Purchase}--you are doing the equivalent of the formula by evaluating on change of the transeq field.

-LB

 

[priyanthan]

Thanks lbass..