I am getting an error since I have a formula in a string but the field is numeric

Marcegon

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

Emmanuel_G

@Marcegon 

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.

Convert numeric field.yxmd