Hi, I have a formula in a string but the field is numeric. Alteryx is suggesting to add the ToNumber formula. How do I apply the ToNumber formula to the statement below? Any help will be much appreciated!
IF IsNull([Approval Budget]) OR [Approval Budget] = 0 AND DATETIMEPARSE([Start_date], "%Y-%m-%d") <= DATETIMEADD(DATETIMENOW(), +14, "days") AND [Involvement] = "Total" AND !CONTAINS([Budget Approver], "spend") THEN "missing" ELSE [Approval Budget] ENDIF
Solved! Go to Solution.
Find in attachement the way of using ToNumber function to convert string to numeric type.
Let me know if there is any issue and do not hesitate to mark this answer as solution if it helped.
Thank you so much! It worked.
One more question, how can I format the number to use 1000 separator (,) and no decimal places.