running total issue

[Former Member]

I have a question regarding running total as below.

I want to display a table like this.

YYYY-MM Monthly MonthlyAccum Target TargetAccum

2011-04 100 100 200 200

2011-05 200 300 200 400

2011-06 500 800 200 600

2011-07 500 1300 200 800

2011-08 0 1300 200 1000

2011-09 0 1300 200 1200

2011-10 0 1300 200 1400

2011-11 0 1300 200 1600

2011-12 0 1300 200 1800

2012-01 100 1400 200 2000

2012-02 0 1400 200 2200

2012-03 0 1400 500 2700

First, I used "running total" for displaying accumulated data.

But it comes one month shift below.

YYYY-MM Monthly MonthlyAccum Target TargetAccum

2011-04 100 0

2011-05 200 100

2011-06 500 300

2011-07 500 800

2011-08 0 1300

2011-09 0 1300

2011-10 0 1300

2011-11 0 1300

2011-12 0 1300

2012-01 100 1300

2012-02 0 1400

2012-03 0 1400

[Former Member · Accepted solution]

Looks like you have placed the Running Total in group header.

RTs can only be used in Footers.

Ian

[Former Member]

Hi,

Try this formula to create Accum. Monthly and Accum. Target :

@Monthly

Whileprintingrecords;

Numbervar AMonth;

aMonth:= aMonth+ // Place this formula in a section where yo have Monthly displayed.

Ceate one more formula simelar to above with a different variable name and use it for Target.

Thanks,

Sastry

[Former Member]

hi,

Follow the below steps.

Edit Running Total Field.

Field to Summarize -> Monthly

Type of Summary -> Sum

Evaluate

For each record

Reset

Never

Regards,

Vamsee