ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests Early 2026. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions. Learn more 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
アステロイド

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件の返信14
jportello
アステロイド

Its still not accepting it: 

jportello
アステロイド

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

apathetichell
アルクトゥルス

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

jportello
アステロイド

I dont understand what you are saying

jportello
アステロイド

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

ラベル
トップのソリューション投稿者