Sum Running Total

[bv0719]

Hello...

I need assistance with running totals not displaying the correct sum at the group level.

Report has 3 groups:

cust.id
cust.masteracct
cust.class

Running totals for each group based on the following:
field to summarize: invoicehist.price
type: sum
evaluate:
{invdth.idhdat} in Date (2008, 1, 01) to Date (2008, 1, 31)
reset:
--- group 1 ---
on change of field - cust.id
--- group 2 ---
on change of field - cust.masteracct
--- group 3 ---
on change of group cust.class

The running totals for group 1 and 2 are correct, however group 3 displays the sum of group 2 and not group 1 and 2.

Basically what I need is:

GRP 1 Customer A - $100.00
GRP 2 Customer B - $150.00
GRP 3 Customer Class Total - $250.00

What it does now:

GRP 1 Customer A - $100.00
GRP 2 Customer B - $150.00
GRP 3 Customer Class Total - $150.00

Is a reset formula necessary for the totals to work? I've also tried adding grp1 and grp2 running totals in a new formula but that did not give the desired result.

Any help appreciated. Let me know if further details are required.

Thanks,
BV

 

[bv0719]

FORGET IT>>>>

I looked over the formulas and determined that the report is working correctly.

Our CFO questioned the values and it seemed they were incorrect but upon further investigation I found the values to be accurate. The results are color coded and this was adding a bit of confusion. Problem solved.

Thanks,
BV