In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

How to subtract two columns, please help

cvill006
5 - Atom

I am attempting to subtract two column on Alteryx but I keep on getting an error message, such as parse error at char(0):Formula: invalid type in subtraction operator. I don't know if it also has to do with me combining two different files together. 

7 REPLIES 7
fmvizcaino
17 - Castor
17 - Castor

Hi @cvill006 ,

 

To perform numeric calculations, you need to change your data type format to a numeric one such as integer, float, double or fixed decimal. You can perform that in your select tools.

 

 

Best,

Fernando Vizcaino

cvill006
5 - Atom

I attempted that but I'm still getting the same message. 

fmvizcaino
17 - Castor
17 - Castor

Would you be able to share your dataset or a sample of it?

Then I can get that to work.

 

Best,

Fernando V.

cvill006
5 - Atom

Yes no problem, I have uploaded it

fmvizcaino
17 - Castor
17 - Castor

Hi @cvill006 ,

 

I also need your csv files if you can. 

 

 

cvill006
5 - Atom

Yes sorry

fmvizcaino
17 - Castor
17 - Castor

Hi @cvill006 ,

 

Without your csv files, I've created a small example calculation between in and out returns. I only changed the format in select tool as I mentioned. 

 

Best,

Fernando V.

Labels
Top Solution Authors