Roundup Issue

[ShaileshDevadiga]

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

[gautiergodard · Accepted solution]

Hey @ShaileshDevadiga 

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

[ShaileshDevadiga · Accepted solution]

@gautiergodard  - Thanks a lot it worked, Thanks for sharing related article for clear understanding