Previous Date condition

[AbhishekGandhi23]

Hello, 

I am facing an issue with the written condition, 

"sum(if(ST.Date = aggr(nodistinct date(max(ST.Date)-1,'MM/DD/YYYY'),measurenm),Field_Name))"

from the above condition, I'm not getting the previous date sum for mentioned field getting output as Zero.

Can anyone please help with the above issue?

[vinieme12 · Accepted solution]

As below

=sum({<ST.Date={"$(=Date(Max(ST.Date,2)))"}>}measurenm)

OR

=sum({<ST.Date={"$(=Date(Max(ST.Date)-1))"}>}measurenm)

[AbhishekGandhi23]

Thanks, @vinieme12  worked!