Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I can not calculate a yesterday's Correl. This expression does not peform any calculation
=Correl({<dat={'$(=Date(Today(1)-1))'},prov={'SIP'}>}[А num],[В num])
I don not have any problem when I calculate for a specific date
=Correl({<dat={'26.04.2020'},prov={'SIP'}>}[А num],[В num])
That is why I assume that my problem is here - dat={'$(=Date(Today(1)-1))'}
I am so sorry! It is correct =Correl({<dat={'$(=Date(Today(1)-1))'},prov={'SIP'}>}[А num],[В num])
Hi, maybe it's because of date format, can you try with?:
=Correl({<dat={"$(=Date(Today(1)-1, 'DD.MM.YYYY'))"},prov={'SIP'}>}[А num],[В num])
Or creating a variable with value : =Date(Today(1)-1, 'DD.MM.YYYY')
And use variable with date formatted: =Correl({<dat={'$(vVariableName)'},prov={'SIP'}>}[А num],[В num])
I am so sorry! It is correct =Correl({<dat={'$(=Date(Today(1)-1))'},prov={'SIP'}>}[А num],[В num])