Rounding to the nearest whole number

Hi All,

I have a really simple rounding issue when using a calcualtion, please see the details below.

I am claculating the following [Quantity Ordered]/[Case Size] & want to round up to whole cases. I have tried using CEIL & ROUND which don't seem to work & return silly numbers so I am clearly missing something. An example of the calcuation is below,

302/6 = 50.3 - this needs to round up to 51.

Please can anyone advise me where this is going wrong? Any help would be appreciated.

Regards

Mark

Tips and Tricks

Accepted answers

NicoleJohnson

Can you show us what sort of answers you are getting instead when using CEIL formula? This one should work: CEIL([Quantity Ordered]/[Case Size])

... so if that's not giving you 51, you may need to check to ensure that your two fields are a numeric data type - if one of them is a string, that might give you some incorrect results?

Let us know!

jdunkerley79

Using a formula tool:

CEIL(302/6)

should return 51.

JoshKushner

If you want to Round Up use: CIEL([num])
If you want to Round Down use: FLOOR([num])

All comments

NicoleJohnson

Can you show us what sort of answers you are getting instead when using CEIL formula? This one should work: CEIL([Quantity Ordered]/[Case Size])

... so if that's not giving you 51, you may need to check to ensure that your two fields are a numeric data type - if one of them is a string, that might give you some incorrect results?

Let us know!

jdunkerley79

Using a formula tool:

CEIL(302/6)

should return 51.

JoshKushner

If you want to Round Up use: CIEL([num])
If you want to Round Down use: FLOOR([num])

markjp85

Thanks for your replies, I used this & it worked perfectly, I had a summerize in the wrong place in my workflow that was causing the numbers issue so everything is now fixed & giving me the correct data.

Premyevale

Hi,

I am wondering if I can use CEIL and floor together..

Like if its 55.4 the result should be 55 and if it is 55.6 then the result should be 56..

Regards,

Prem

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15875

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703