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

Question

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 · Answer

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.

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

Hope this solves your concern.