Changing date to variable in set analysis

gilldilpreet — Tue, 06 Oct 2020 11:20:31 GMT

Hi,

I am trying to change the dates in the expression below to variables i.e. today() and today()-1 and today()-2 etc.

I have tried using the expression underlined in red but this doesn't seem to be working.

Could someone advise please?

Thanks

Dilpreet

Re: Changing date to variable in set analysis

Taoufiq_Zarra — Tue, 06 Oct 2020 12:44:46 GMT

sum({<[Session Date]={"$(=Date(today(),'DD/MM/YYYY'))"},....>}