Parse Error (tried to apply numeric operator to string value)

[Claudia]

Hi Alteryx experts,

I am experiencing errors with the formula below. Would greatly appreciate any help. 

Thank you!

[DataNath]

Hey @Claudia, you'll need to check the datatypes here. As the error message mentions, one of your fields - [ENDING BALANCE] or [GENERAL LEDGER BALANCE] - or both, are actually strings rather than numeric and you therefore can't subtract them/treat them as numbers without fixing this. You can either put a Select tool beforehand and make them a numeric type like a double, integer etc. (or, because you're creating the ENDING BALANCE field in a Formula beforehand, just make it numeric there as the default is string) or, within the expression itself, wrap them in ToNumber() so it'd be:

ToNumber([ENDING BALANCE])-ToNumber([GENERAL LEDGER BALANCE])

[Damian_WRO]

Hi, Make sure that your ENDING BALANCE field you created in a 'Formula' tool is a Numeric type, not String. Make also sure that GENERAL LEDGER BALANCE is numeric, you can check that under 'Select' tool you used in your workflow. Please also correct data type in DIFFERENCE formula tool to any Numeric type.

[Claudia]

DataNath  Damian_WRO thank you for your great help!

[caltang]

Hi @Claudia ! If it helped, can you kindly mark @Damian_WRO and @DataNath 's comments as accepted solutions? This helps close the thread and helps others find the solution as well. Thanks!