Expression for Yesterday

[#1]

Hi,

How can i write the expression for yesterday. I want to get the sum of sales for yesterday using expression. Please help me..

Thanks

Renjith Kumaran

[Gysbert_Wassenaar]

Try sum({<MyDate={'$(=date(today()-1))'}>} sales). Change MyDate to the name of your date field and sales to the name of your sales field.

[#3]

No, It gives me off values..

[rustyfishbones]

You can try it with Double Quotes maybe

SUM({<Date = {"$(=DATE(TODAY()-1))"}>} Sales)

[#5]

That too gave me off values..

My situation is that i have two dimension named process center and Driver. i want to write a expresssion for the graded quantity and want that without selecting the date.

That is its 6/11 today. on loading the chart i want to fill the pivot tabke with yesterday's sum(gradedqty).

Thanks

Renjith Kumaran

[sujeetsingh]

Ren ,

Try to calculate the yesterday as Date -1 in script.