Today minus 1

[thomas_2583]

Hi, 

I have the following logic to look at yesterday's volume but the logic I have, doesn't return any results (there is data from yesterday). Any idea what is wrong with the logic used please? 

Sum({$<[Date_new] = {"$(=Today()-1)"}>}Volume)

Date_new format is YYYY-DD-MM

Thanks

[tresB]

Try putting the date format like:

Sum({$<[Date_new] = {"$(=Date(Today()-1,'YYYY-DD-MM'))"}>}Volume)

[jonathandienst]

You can try this:

Sum({$<[Date_new] = {"$(=Date(Today()-1, ' YYYY-DD-MM')"}>} Volume)

If that doesn't work, you may need to override some date selection(s), or all selections:

Sum({1<[Date_new] = {"$(=Date(Today()-1, ' YYYY-DD-MM')"}>} Volume)