Sum with MAX MonthKey

[GDunn1]

Hi,

I am attempting to return a value where the max MonthKey is selected. The below is accepted but returns zero values. I wonder if it is because each product line may not have a consistent max date...

It seems like a simple formula but I cannot get it to return values. Any help appreciated

num(sum( {max<MonthKey>} ClosingFUA ))

[Vegar · Accepted solution]

Try this

sum( {<MonthKey={'$(=max(MonthKey))'} >}ClosingFUA )

[GDunn1]

Thanks @Vegar works perfectly