How to insert grouping's summary in formula crystal reports? 1

[Jes5ie]

Here's how the situation: I group all the ID together, which mean, I will get a summarized number from each of the ID. The field name is "Sum of table.amount"

FYI, The formula is used to sum up the summarized number and other data.I typed {Sum of table.amount} + {table.amountB} for the formula but it won't works.

May I know how to get the summarized number into my formula? Thank you.

 

[IanWaterman]

sum({table.amount}, {table.IDField}) + {table.amountB}

This will only add last value found for {table.amountB} to the sum of the amounts in the ID group

Ian

 

[Jes5ie]

Thank you. I didn't know that the sum function can be used like that. Thank you again. ))

 

[Madawc]

It's also worth getting familiar with Crystal's automatic totals, this is outlined at FAQ767-6524. A lot of the time, you can get the result you want with just a few clicks.

Madawc Williams (East Anglia, UK). Using Crystal 11.5 with SQL and Windows XP