Hello,
I have two groups setup in a report based off of GL and BANK. They are as follows:
GL BANK BUDGETYTD
{GL1} {GL1 TOTAL}
{BANK1} {BANK1 TOTAL}
{BANK2} {BANK2 TOTAL}
{BANKx} {BANKx TOTAL}
{GL2} {GL2 TOTAL}
{BANK1} {BANK1 TOTAL}
{BANK2} {BANK2 TOTAL}
{BANKx} {BANKx TOTAL}
{GLx} {GLx TOTAL}
{BANK1} {BANK1 TOTAL}
{BANK2} {BANK2 TOTAL}
{BANKx} {BANKx TOTAL}
The Bank totals seem to be running fine; I have them set to sum each record of BANKYTD resetting on change of the group based on BANKx. However, I'm trying to do the sum of BANKYTD resetting on change of the group based on GLx, but all it's doing is pulling in the value of BANK1 TOTAL ( {GLx TOTAL} = {BANK1 TOTAL} ).
Any thoughts on what might cause this and/or how to fix it?