How to subtract two columns, please help

[cvill006]

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. 

[fmvizcaino]

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]

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

[fmvizcaino]

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

Then I can get that to work.

Best,

Fernando V.

[cvill006]

Yes no problem, I have uploaded it

[fmvizcaino]

Hi @cvill006 ,

I also need your csv files if you can. 

[cvill006]

Yes sorry

[fmvizcaino · Accepted solution]

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.