set analysis

[nareshthavidishetty]

Hi ,

My expression is sum(sales) but i need to modify that as sum(sales) from vYesterday to vPast varisbles.

Thanks..

[sunny_talwar]

Can you provide more information? What is vYesterday? What is your date field? It's format... etc etc

Dates in Set Analysis

[nareshthavidishetty]

HI ,

Please find below.

vYsterday = date(today()-1,'M/D/YYYY');

vPast = date(today()-28,'M/D/YYYY');

Where Date=Today

Thanks..

[Anonymous]

Sum({$<Date={'>=$(=Date(vPast, 'M/D/YYYY'))<=$(=Date(vYsterday, 'M/D/YYYY'))'}>} Sales)

[nareshthavidishetty]

Hi,

It's not working..

Thanks..

[Anonymous]

what is date field name ?

[nareshthavidishetty]

Field Name =Date

Thanks..

[Anonymous]

Sum({<Date = {">=$(=Date(Today()-28,'MM/DD/YYYY'))<=$(=Date(Today()-1,'MM/DD/YYYY'))"} } Sales)

Or

Sum({<Date = {">=$(=Date(Today()-28,'M/DD/YYYY'))<=$(=Date(Today()-1,'M/DD/YYYY'))"} } Sales)

I have doubt on your    "Date"  field format ...