Set Analysis - Previous Day Issue

[#1]

Hi All,

Can anybody tell me what I am doing wrong here? Using the following expression to bring back the previous days sales:

=sum({$<date = {"=$(=Date(max(date) -1))"}>} revenue)

However this is just returning the currently selected dates sales.

Any help appreciated (I am sure it something simple I just cannot see it!)

Cheers,

Andrew

[nilesh_gangurde]

Please Try this,

sum({$<date = {"$(=Date(max(date) -1))"}>} revenue)

Also check the date format and then have the same format within the double quotes.

-Nilesh

[timsaddler]

I've just been doing a similar thing

I set up variables for date ranges

Let  vTimeStart1 = Num(Today()-22);

Let vTimeStart2 = Num(Today()-9);

Then Expression as below :-

( {$< GLDate = {">=$(vTimeStart1) <=$(vTimeStart2)" }>} #SalesTns)

This might help

[somenathroy]

You may try with date format as:

=sum({<date = {'=$(=Date(max(date) -1,"DD/MM/YYYY"))'}>} revenue)

Date format(DD/MM/YYYY) should be as same as 'date' field has.

Regards,

Som