Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask here!
Start 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
20 - Arcturus

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