Announcements
No record found.
I am trying to find a solution that can round up the pallet quantity to the nearest whole number. For example if the value is <0.5, it should round it up to 1 instead of rounding down to 0. Can someone help me find a solution to this please
If you have written some AL Code around this you should use the round function.
round(Pallets,1,'>');
This will round up to nearest integer.
docs.microsoft.com/.../system-round-method
Thank you, I will try this out
Hi, If it's an amount, you can modify the Rounding Type in the settings below.
If it is quantity, it may need to be customized.
More details: ROUND Function (Decimal)
https://docs.microsoft.com/en-us/dynamics-nav/round-function--decimal-
Hope this helps as well.Thanks.
ZHU
Thank you
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our 2026 Super Stars!
We are thrilled to have these Champions in our Community!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
OussamaSabbouh 1,993 Super User 2026 Season 1
YUN ZHU 1,116 Super User 2026 Season 1
Khushbu Rajvi. 557 Super User 2026 Season 1