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

[Notemba]

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]

[OllieClarke]

Hi @Notemba you don't need to start formulae with an '=' in Alteryx. Try:

[Expected Ending Balance] - [Amounts 2019]

Ollie

[Notemba]

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)

[clmc9601]

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]). 

[BretCarr]

@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!