Previous Day Sales

[wassimharfoush]

I am trying to get previous day sales. I tried this expression but did not work:

=Sum({$<DatField={'$(VarPreviousDay)'}>}SalesField)

The variable set as follow:

VarPreviousDay=Date(Today()-1,'MM/DD/YYYY')

[Gysbert_Wassenaar]

That should work if you use the same date format that DatField has, but only if you don't use DatField as dimension in your chart. A set analysis expression calculates one set per chart, not a set per row.

[aveeeeeee7en]

Hi wassim

First check that both formats are same or not.

You have made your variable date in 'MM/DD/YYYY' format.

Please check that your DatField is in the 'MM/DD/YYYY' format ir not.

If not than try changing it.

If Yes, than use this expression:

=Sum({$<DatField={'$(=(VarPreviousDay))'}>}SalesField)

Also, see the Attachment.

Regards

Aviral Nag

[wassimharfoush]

The date format is the same format as the variable. And is not working for me any other suggestions?

[Gysbert_Wassenaar]

Post an example document that demonstrates the problem.

[muniyandi]

Hi Wassim,

your variable front of put equal.

try this expression.

Sum({$<DatField={'$(=VarPreviousDay)'}>}SalesField)

variable front of put equal.

Thanks,

Muni