I am getting a Parse error at char (160) invalid type in operator = =. (Expression # 3).

[Marcegon]

I am getting a Parse error at char (160) invalid type in operator = =. (Expression # 3) on the (2) rules below.  I am using a CSV file.  What is wrong?  Help please!

IF IsNull([Actual virtual attendees]) AND [Actual in-person attendees] = 50000 THEN 50000 Else [Actual virtual attendees] ENDIF

IF IsNull([Approval Budget]) OR [Approval Budget] = 0 AND DATETIMEPARSE([Start_date], "%Y-%m-%d") <= DATETIMEADD(DATETIMENOW(), +14, "days") AND [Involvement] = "Total" THEN 00 Else [Approval Budget] ENDIF

[Amol_Telore]

Hey @Marcegon 

When your input dataset is CSV file, all the fields are assigned V_STRING data type. As per your formula, you are trying to compare V_STRING data type with a number hence you are receiving this error. In order to resolve this issue, there are two approaches.

1. Change the data type with appropriate data type and then use formula tool.
2. Put double inverted quotes around numbers ex. "50000", "0" etc.

Hope this solves your concern.