Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
THis should be simple but obviously doing something wrong. I want Expression 2 to accumulate on expression 1 - it should look like "What I want" column but all it is doing is returning the same number for the current row.
Expression 1: SUM({<[Tran Desc]={'Payroll','payroll'}>}[Amount GL])
Expression 2: RangeSum(Above(SUM({<[Tran Desc]={'Payroll','payroll'}>}[Amount GL]),0,RowNo()))
Month/Year | Expression 1 | Expression 2 (not working as expected) | What I want |
Jan-15 | 4,500.00 | 4,500.00 | 4,500.00 |
Feb-15 | 4,500.00 | 4,500.00 | 9,000.00 |
Mar-15 | 24,568.81 | 24,568.81 | 33,568.81 |
Apr-15 | 4,500.00 | 4,500.00 | 38,068.81 |
May-15 | 4,500.00 | 4,500.00 | 42,568.81 |
Jun-15 | 1,991.79 | 1,991.79 | 44,560.60 |
Jul-15 | - | - | 44,560.60 |
Aug-15 | - | - | 44,560.60 |
Zag
Try:
RangeSum(Above(SUM({<[Tran Desc]={'Payroll','payroll'}>}[Amount GL]),0,RowNo(TOTAL)))
- Marcus
Check enclosed file..
And don't forget if your chart is a straight table, that you have the 'Accumulation' options.