I want to know a yesterday's corell.

[vmonitor]

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))'}

[rubenmarin]

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]) 

[vmonitor · Accepted solution]

I am so sorry! It is correct =Correl({<dat={'$(=Date(Today(1)-1))'},prov={'SIP'}>}[А num],[В num])