Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Merry Christmas everyone,
I am needing to create a calculated field that will give me late and ontime. this is what I have but I am getting syntax errors.
Any suggestions?
IF
([AUDIT_DUE] = {"<=$(=Date(Today(),'MM/DD/YYYY'))"}>}'On Time', 'Overdue') as [On Time],
You cannot use set analysis in the script. So [AUDIT_DUE] = {"<=$(=Date(Today(),'MM/DD/YYYY'))"}>} is meaningless in the script. It's also not correct when used in an aggregation function in a chart expression.
Try instead: if([AUDIT_DUE] <= today(), 'On Time', 'Overdue') as [On Time]
You cannot use set analysis in the script. So [AUDIT_DUE] = {"<=$(=Date(Today(),'MM/DD/YYYY'))"}>} is meaningless in the script. It's also not correct when used in an aggregation function in a chart expression.
Try instead: if([AUDIT_DUE] <= today(), 'On Time', 'Overdue') as [On Time]
Hello Leo,
Don't forget to mark answers as helpful or correct.
Thanks for sharing the solution you found and closing the discussion.
,KR Koen
That did it.
thank you