Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi ,
I am trying this expression but it was not getting correctly , how to show yesterday sales ?
=Sum(Fabs({<VOU_DATE={"$(=Max(VOU_DATE)-1)}>}G.NET_WT))
i tried this, this was working as per expected.
=Sum({<VOU_DATE= {"$(=Date(Floor(Max(VOU_DATE)-1),'DD-MMM-YYYY'))"}>}fabs( G.NET_WT))
Try this:
=sum({<VOU_DATE= {"$(=Date(Floor(Max(VOU_DATE)-1)))"}>} NET_WT)
Hey,
Max(VOU_DATE)-1) will return yesterday's date but it will be in Number format. Make sure to define it in date format similar to VOU_DATE format.
For example:
Sum(Fabs({<VOU_DATE={"$(=Date(Max(VOU_DATE)-1),'DD/MM/YYYY')}>}G.NET_WT))
Hope it helps.
-amrinder
Hi,
if i keep fabs then it was throwing error in script.
=sum(fabs({<VOU_DATE= {"$(=Date(Floor(Max(VOU_DATE)-1),'DD-MMM-YYYY'))"}>} G.NET_WT))
i need to give fabs in the expression.
I am not sure why you are using Fabs but in case you really need it use it in the Set analysis:
=sum({<VOU_DATE= {"$(=Date(Fabs(Floor(Max(VOU_DATE)-1),'DD-MMM-YYYY')))"}>} G.NET_WT)
i tried this, this was working as per expected.
=Sum({<VOU_DATE= {"$(=Date(Floor(Max(VOU_DATE)-1),'DD-MMM-YYYY'))"}>}fabs( G.NET_WT))