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.
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.
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.
Fernando Vizcaino
I attempted that but I'm still getting the same message.
