How to show yesterday sales in the pivot table ?

[venkat1]

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))

[MindaugasBacius]

Try this:

=sum({<VOU_DATE= {"$(=Date(Floor(Max(VOU_DATE)-1)))"}>} NET_WT)

[amrinder]

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

[venkat1]

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.

[MindaugasBacius]

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)

[venkat1 · Accepted solution]

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))