RESOLVED: Last Running Aggregate value in Summary

[ahmerzaidi]

I'm having trouble figuring out how to display the last value of a running aggregate (in this case running-total) of a group with in the summary section of a list.

No matter what I tried to do I was always getting the beginning value.  So how to I display the final running aggregate value of a group in the summary row?


Example:
What I Get

Label	Debit	Credit	Balance
Beginning Balance			100
A	160	0	260
B	0	40	220
C	10	0	230
Summary	170	40	100

What I Need

Label	Debit	Credit	Balance
Beginning Balance			100
A	160	0	260
B	0	40	220
C	10	0	230
Summary	170	40	230

[ahmerzaidi]

Issue Solved:

I created a copy of the data item that calculated the running-total and replaced "Running-Total" with "Total"... Worked for what I needed to do.

[RL_Boston]

Hi - I'm trying to figure out your first step, What is your calculation for the Balance Column?

                          (Debit - Credit) = Balance
Then, Balance + (Debit - Credit) = New Balance