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
@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
@Neji pls attach the data or workflow
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.
