Previous Day - Set analysis - Not working

[#1]

Hi All,

I need to be able to display the selected dates data, and the previous days data, but I am not including any date fields in my pivot table.

I am using this expression, but it is giving me 0.

Sum ({$< [As at Date] ={"$(=Only([As at Date])-1)"}>}  [MTM P/L(USD)])/1000

Please can you help?

Thanks

Sally

[swuehl]

Try formatting your set modifier the same way as your date, e.g.

Sum ({$< [As at Date] ={'$(=Date(Only([As at Date])-1,'MM/DD/YYYY')) '}>}  [MTM P/L(USD)])/1000

[#3]

Hi,

Thanks for the quick response.

That still gives me a zero value.

This gives me the same value as the selected days data:

Sum ({$< [As at Date] ={"=$(=Date(Only([As at Date])-1,'MM/DD/YYYY'))"}>} [MTM P/L(USD)])/1000

I have also managed to get a total of all previous values using <=, but I just cannot get the selected value, - 1 day.

Slightly annoying.

[SunilChauhan · Accepted solution]

Sum ({$< [As at Date] ={"$(=Date([As at Date]-1))"}>}  [MTM P/L(USD)])/1000

hope this helps

[#5]

Sunil,

You are a star....thank you so much!!!