SOLVED
Roundup Issue
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
ShaileshDevadiga
7 - Meteor
‎11-20-2022
06:23 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi,
I am trying to roundup to 4 decimal , in excel it shows different as compared to Alteryx.
In excel I am trying to reduce to 4 decimal using increase/ decrease decimal function
In Alteryx I am using round(Average),0.0001)
One is Bold is showing different number, am I using wrong formula in Alteryx
Actual Avg Price | In Excel rounded up to 4 decimal | In Alteryx, rounded upto 4 |
1414.045900 | 1414.0459 | 1414.0459 |
1422.931500 | 1422.9315 | 1422.9315 |
1432.762500 | 1432.7625 | 1432.7625 |
1438.896525 | 1438.8965 | 1438.8965 |
1444.422960 | 1444.4230 | 1444.4230 |
1444.087850 | 1444.0879 | 1444.0878 |
1445.679757 | 1445.6798 | 1445.6798 |
1450.530588 | 1450.5306 | 1450.5306 |
1452.628889 | 1452.6289 | 1452.6289 |
1454.240020 | 1454.2400 | 1454.2400 |
Solved! Go to Solution.
Labels:
- Labels:
- Common Use Cases
- Data Investigation
2 REPLIES 2
gautiergodard
13 - Pulsar
‎11-20-2022
06:40 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
You can use the solution below to do the trick.
round(round([Actual Avg Price],.00001),.0001)
Also including a related article that explains how this works: Solved: Alteryx Odd Behavior - Alteryx Community
‎11-20-2022
07:17 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@gautiergodard - Thanks a lot it worked, Thanks for sharing related article for clear understanding
