Forum Discussion

EudonDelemar's avatar
EudonDelemar
Qrew Trainee
6 years ago

How to change a decimal to whole number

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?
Formulas and functions

3 Replies

Sort By
  • _anomDiebolt_'s avatar
    _anomDiebolt_
    Qrew Elite
    6 years ago
    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.