Set analysis (Latest value)

[Anonymous]

ID	# OF PAYMENT	Value
001	1	100
001	2	150
001	3	175
002	1	50
003	1	100
003	2	100

This expression =SUM({$<[# OF PAYMENT]={$(=max([# OF PAYMENT]))}>}Value) returns value= 175 because it has the latest  payment which is not the desired result.

I need an expression that returns 175 +  100 + 100 = 375  because the latest payment for ID 001 is 175, ID 002 IS 50 and ID 003 is 100.

Thanks

[Gysbert_Wassenaar · Accepted solution]

Try =sum(aggr(FirstSortedValue(Value,-[# OF PAYMENT]),ID))

btw, the result is 325, not 375

[preminqlik]

hi,

PFA

hope it helps u

regards

Premhas

[Anonymous]

Thanks alot guys