Formulas and Groups

[Former Member]

Post Author: vondee

CA Forum: Crystal Reports

I have a report grouped by year, with a percent total for each year that is calculated in a formula from running totals:

2004 - XX%

2005 - XX%

2006 - XX%

2007- XX%

I want to add a formula next to the percent that calculates the difference between that year's XX% and the previous year. So the result of 2007 XX% - 2006 XX% appears in the 2007 group. The result of 2006 XX% - 2005 XX% appears next to 2006, etc.

Is this possible in Crystal? Thanks for any ideas-

[Former Member]

Post Author: kcheeb

CA Forum: Crystal Reports

Seems to me there's a prevrow function that can be used to return a value. Not sure if I'm remembering correctly or not and what the behaviour is in a group.

[Former Member]

Post Author: fusion

CA Forum: Crystal Reports

This should be possible using just the sum but if you use running total, it might give you incorrect result.

[Former Member]

Post Author: fusion

CA Forum: Crystal Reports

you should try to avoid Running Totals.