Skip to main content
Question

How to change a decimal to whole number

  • November 20, 2018
  • 0 replies
  • 96 views
I have a number field labeled QTY. I have another field labeled Final totals that looks at the QTY field and divides by 2. But if its a decimal i need it to round up to a whole number.

For example: if QTY=7 the Finals Totals: 3.5. It should be 4 for the Final Totals.

Is this possible with a formula?
    This topic has been closed for replies.

    • ZVIBOCK
    • Registered
    • November 20, 2018
    Just use the Round() function on the result
    • EudonDelemar
    • Author
    • Registered
    • November 20, 2018
    Thanks, that work perfectly.
    • anomDiebolt
    • Registered
    • November 21, 2018
    Actually if you want to consistently round up you should use Ceil([Qty]/2) as Round([Qty]/2) rounds to the nearest integer. Round([Qty]/2) appears to work only because your [Qty] in an integer.
    Terms & ConditionsAccessibility statement