Announcements
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.
As AI tools become more common, we’re introducing a Responsible AI Use…
Thanks to all of our 2025 Community Spotlight stars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
OussamaSabbouh 2,042 Super User 2026 Season 1
Dhiren Nagar 1,077 Super User 2026 Season 1
YUN ZHU 1,068 Super User 2026 Season 1