Subtraction

[amorej]

Such a simple thing but I keep getting a "Parse Error".  I don't know why.  I am trying to add a column that will contain Gross Amount 2 - DTV Revenue Keep

[IraWatt · Accepted solution]

Hey @amorej,

This error happens when the data types your using are incorrect. You can only add and subtract numbers, your data is text shown here:

Set your columns to be a numeric data type such as a double:

And the formula will work.

Any questions or issues please ask

Ira Watt
Technical Consultant
Watt@Bulien.com 

[DataNath]

Hey @amorej, have you double checked the data types of your 2 fields? Most likely one of them is still a string and you’re trying to apply numerical functions to it.

[MarqueeCrew]

@amorej ,

The default datatype is  a STRING.  Each of your components for "Subtraction" needs to be a numeric data type {Byte, Int, Double, Fixed, Float}.

If you look at the type that you are currently subtracting, you'll see that it isn't numeric.  My guess is that the other fields referenced are  not either.

Cheers,

Mark

[amorej]

Thank you.  That worked.  

[IraWatt]

No worries @amorej  😄 You can find some good quick videos on how data types work here on the community Understanding Data Types - Alteryx Community or just check the docs your feeling brave Data Types | Alteryx Help.