Aggr Max(Date)

[GianluigiBI]

Hi guys, 
i have this formula that is not working correctlly: 

Sum({$<unload_flag_50={"=1"}, date={"$(=Aggr(Max(date)),shop)"}>} [account_balance_eur])

The point is that I need to Aggregate Max(date) for each shop, and than take the sum. 
Why it isn't working? Any ideas?

[BrunPierre · Accepted solution]

Try

=FirstSortedValue(Aggr(Sum({$<unload_flag_50={"=1"}>} [account_balance_eur]),shop,date),-date)

[agigliotti]

Hi @GianluigiBI ,

What object type are you using for that expression?

[GianluigiBI]

Thaks so much, it is working!

[GianluigiBI]

I found that it doesn't work well with negative values

[BrunPierre]

@GianluigiBI Can you elaborate?