Extracting data from excel file there is two coloumns

[Neji]

i am not able to subtract between two colomns and if at all i am selecting type as double from string whole data gets changed can somone help out

[stataltgee]

@Neji pls attach the data or workflow

[atasmohd]

If you attach the data so we can address the issue, or you can follow the simple process below. 

-> Select Tool for change dataType

-> Formula Tool for clean data if needed, then convert into Double

-> Finally, Formula Tool for subtract column [col1]-[col2]

This will work if both are already numeric.

[abacon · Accepted solution]

@Neji You can use ToNumber() in a formula to convert a string to a number within the tool for calculation. It would be ToNumber([Col1])-ToNumber([Col2]) and that will get you your answer.

The issue is most likely with datatypes @atasmohd alluded to.

Bacon