Transfer formula from set analysis to script editor

[JoannaM]

Hi all

I would like to transfer a part from my formula in set analyis to the script editor.

I need to show the data from beginning of this month until today. 

Set analysis formula:

sum({<%date={"<$(=today())"}>}[prod days])

to editor.

How will {<%date={"<$(=today())"}>} look like in the script editor?

Thanks for any help.

Best regards, Joanna 

[neerajthakur · Accepted solution]

if(MonthStart(date)<=Today(),Sum([prod days]),0) as Sum_Prod_Days

Make sure format of MonthStart(date) is same as Today(), you can use Num() in front of both to make this happen.

[JoannaM]

Hi 

Thanks for your help. It worked. 

if(%date<=Today()-1,([prod days]),0) as "prod days temp10"

Have a great day! 

Best regards, Joanna