Get value of the field by max value of another

[yura_ratu]

Hi all,

How can I found value of one field, corresponded to max value of another field. In a chart

Example attached. Thank you

[robert_mika]

Try:

sum({$<Date={$(= max (ID))}>}Value)

[rubenmarin · Accepted solution]

Hi Yuriy, set analysis won't work if you want to calculate it row by row, you can use an expression like:

Aggr(If(Date=Max(TOTAL <ID> Date), Sum(Value)), ID, Date)

[yura_ratu]

I guess you meant

sum({$<Date={$(= max (Date))}>}Value)

Doesn't work. It tries to find max date from all model in every ID. But I need to calculate max date for every specific ID

[yura_ratu]

Hi Ruben. It works! Thanks a lot