Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I'm working with account balances, and I can't quite get the semi-additive expression to work.
I would like to sum the latest balances for each account # and id for the selected date range.
example:
Acct # | Id | Post Date | Sequence # | Balance |
Total | $43,835.03 | |||
0000000045 | 08 | 6/30/2017 | 1812224 | $18,330.17 |
0000000045 | 08 | 5/31/2017 | 1692314 | $18,307.74 |
0000000045 | 08 | 4/30/2017 | 840965 | $18,284.60 |
0000000045 | 08 | 3/31/2017 | 1781804 | $18,262.23 |
0000000045 | 08 | 2/28/2017 | 1856632 | $18,239.14 |
0000000045 | 08 | 1/31/2017 | 1617917 | $18,218.31 |
0000000101 | 60 | 6/30/2017 | 1812256 | $25,504.86 |
0000000101 | 60 | 5/31/2017 | 1692322 | $25,473.66 |
0000000101 | 60 | 4/30/2017 | 840982 | $25,441.46 |
0000000101 | 60 | 3/31/2017 | 1781836 | $25,410.34 |
Has anyone had any experience with this type of expression?
Thanks
Is this how you want to see in a chart or are you just looking to get the total in a text box object?
Sorry I should have been more specific. I'd like to see it in a straight table. Thanks
Sent from my Sprint Samsung Galaxy S7.
May be something like this? Havent Tried
= Sum(TOTAL {< [Post Date] = { "$(= Max([Post Date]))" } >} Balance)
Rowwise you want to see everything, but total should only include the most recent value?
What are you expecting to look in this straight table like below?
= Sum(TOTAL <[Acct #], Id> {$< [Post Date] = { "$(= Max([Post Date]))" } >} Balance)