topic Re: Previous Date condition in App Development

Previous Date condition

AbhishekGandhi23 — Tue, 18 Oct 2022 04:55:42 GMT

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 — Tue, 18 Oct 2022 05:43:24 GMT

As below

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

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

AbhishekGandhi23 — Wed, 19 Oct 2022 06:38:52 GMT

Thanks, @vinieme12 worked!