How does the found function work in Ax
num = round(num,0.01);
What is the function of the second argument
*This post is locked for comments
How does the found function work in Ax
num = round(num,0.01);
What is the function of the second argument
*This post is locked for comments
Thank You!
Hi
You can check this for more details:
docs.microsoft.com/.../xpp-math-run-time-functions
The second function is basically a multiplier of the number you want to round off to.
So, if you want to round 11 off to the nearest multiple of 5 (which would be 10), you'd use round(11, 5)
If you want to round 51 to the nearest multiple of 100 (which would be 100), you'd use round(51, 100)
if you want to round 9.8 to the nearest whole number, or to the nearest multiple of 1 (which would be 10), you'd use round(9.8, 1)
So basically, if you want to round off to a certain number of decimal places you'd use round(myNum, 0.00001) where 0.00001 includes the number of decimals you want to round off to
Round also doesn't only round up, it rounds down if down is the nearest number to round to
Hope this helps
André Arnaud de Cal...
292,516
Super User 2025 Season 1
Martin Dráb
231,436
Most Valuable Professional
nmaenpaa
101,156