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 |
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.
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