Alteryx not calculating the difference between two columns correctly
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
jportello
8 - Asteroid
‎08-22-2024
07:58 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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)
Labels:
- Labels:
- Common Use Cases
- Output
- Transformation
14 REPLIES 14
‎08-22-2024
11:35 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Its still not accepting it:
‎08-22-2024
11:39 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
apathetichell
19 - Altair
‎08-22-2024
11:42 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
tonumber - not tostring. totsring -> to string to number -> to number.
‎08-22-2024
11:56 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I dont understand what you are saying
‎08-22-2024
11:57 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
You said in your original post to write to string and then later that "mult' is wrong which is needed to the round formula?

- « Previous
-
- 1
- 2
- Next »