Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
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