Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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.
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