web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Answered

Rounding precision for pallet quantity

(0) ShareShare
ReportReport
Posted on by 100

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

I have the same question (0)
  • Suggested answer
    Inge M. Bruvik Profile Picture
    1,153 Moderator on at

    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

  • SV1 Profile Picture
    100 on at

    Thank you, I will try this out

  • Suggested answer
    YUN ZHU Profile Picture
    97,376 Super User 2026 Season 1 on at

    Hi, If it's an amount, you can modify the Rounding Type in the settings below.

    pastedimage1663199374488v1.png

    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

  • Verified answer
    SV1 Profile Picture
    100 on at

    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.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,042 Super User 2026 Season 1

#2
Dhiren Nagar Profile Picture

Dhiren Nagar 1,077 Super User 2026 Season 1

#3
YUN ZHU Profile Picture

YUN ZHU 1,068 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans