Subtraction in alteryx

[aakanksha_garg]

HI, i am trying to subtract two column and i want the answer in simple decimal number format using formula tool. How can i approach this?

For example

Coulmn 1	Column 2
8936.10	8963.25

I want another column called "Comparsion" and its result as 0.15 but alteryx gives me result as 1.5e-1.

[atcodedog05 · Accepted solution]

Hi @aakanksha_garg 

Try this

Hope this helps : )

[aakanksha_garg]

It worked!

Thank You so much!

[atcodedog05]

Happy to help : ) @aakanksha_garg 

Cheers and have a nice day!