Next/Previous Subtotal 1

[jim1959]

I have a simple report with a group on a date field, by month and a subtotal on a currency field. My client wants to show the percent change from one month (subtotal) to the next. The only thing I can think to do is set up a couple of variables and have one reset on odd-numbered groups and the other on even-numbered groups, but that seems kind of clunky. The Next and Previous functions don't seem to like working with summary fields. This seems as though it should be easy to do, but I'm stumped. Thanks.

 

[lbass]

Create a formula like this:

whileprintingrecords;
numbervar prev;
numbervar sumamt := tonumber(sum({table.amt},{table.date},"monthly"));
numbervar chg;

if groupnumber = 1 then
chg := 0 else
chg := (sumamt-prev) % prev;
prev := sumamt;
chg

Place this in a group section along with the summary.

-LB