Calling all Alteryx customers: Refer your colleague to try Alteryx and receive a $50 gift card. Sign up now!
Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Alteryx not calculating the difference between two columns correctly

jportello
8 - Asteroid

I have a simple workflow calculating the difference between two periods but the formula isn't working correctly. I have attached snip of workflow and excel of the output showing the inaccuracies. (some of the rows are being calculated correctly)

14 REPLIES 14
jportello
8 - Asteroid

Its still not accepting it: 

jportello
8 - Asteroid

Alteryx stil isnt accepting the formula..... tried both options below

apathetichell
19 - Altair

tonumber - not tostring. totsring -> to string to number -> to number.

jportello
8 - Asteroid

I dont understand what you are saying

jportello
8 - Asteroid

You said in your original post to write to string and then later that "mult' is wrong which is needed to the round formula? 

Labels
Top Solution Authors