Returning a value for the latest month when more than one month is selected?

[#1]

Hi all,

I have some data which represents the count of devices. I would like to write an expression which returns the count of devices for the most recent month selected. For example. If the user has selected Jan, Feb, Mar, I would like the expression to sum up the count of devices for March only. I have attached an example. In this example I wanted the expression in the blue text object to return "7" with Jan, Feb, and Mar selected.

I have tried max(Month) unsuccessfully - would someone be able to advise the best way to achieve this?

Many thanks

[Anonymous · Accepted solution]

How about something like :

=sum ({ < MonthYear={'$(=max ( MonthYear ))'} > } Machine_Count )

[#3]

Thank you!

[#4]

Why it not works for Max(Month)? and works for Max(MonthYear)?

What is the logic?