Semi additive measure

[Anonymous]

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

[sunny_talwar]

Is this how you want to see in a chart or are you just looking to get the total in a text box object?

[Anonymous]

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.

[vishsaggi]

May be something like this? Havent Tried

= Sum(TOTAL {< [Post Date] = { "$(= Max([Post Date]))" } >} Balance)

[sunny_talwar]

Rowwise you want to see everything, but total should only include the most recent value?

[vishsaggi]

What are you expecting to look in this straight table like below?

= Sum(TOTAL <[Acct #], Id> {$< [Post Date] = { "$(= Max([Post Date]))" } >} Balance)