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