Parse Error at char(0): Parse Error (Expression #1)

Question

Hi I am attempting to subtract one column from another column however I keep getting the following error:

Error: Formula (13): Parse Error at char(0): Parse Error (Expression #1)

See below for formula:

=[Expected Ending Balance]-[Amounts 2019]

BretCarr · Answer

@clmc9601 is likely spot on. To do mathematics with your fields, you need to make sure they are the correct format. In your case, you need to pick a number format. You can use the Select Tool or just do it in your formula as clmc suggested!

Happy solving!

clmc9601 · Answer

Hi @Notemba,

That error means one of your referenced fields is stored as a string. Based on "char(0)", I'd guess it's the first one. You'll need to change the field to a numeric data type (like with a select tool) or temporarily change it to a number in your expression with ToNumber([field]).

Notemba · Answer

Hi,

Thank you for getting  back to me so quickly.

I am still getting the below error message:

Error: Formula (13): Parse Error at char(0): Formula: invalid type in subtraction operator (Expression #1)