Aug 09, 2023 08:32 AM
I'm rounding up a field called "Total Hours" using ROUNDUP(). Total Hours is a field that adds 2 decimal numbers together. The decimals numbers have up to 3 decimal places.
My understanding is that ROUNDUP({Total Hours}, 2) works like this: it will round up to 2 decimal places if any number after the 2nd decimal place is above 0.
Example ROUNDUP(72.001, 2) = 72.01
ROUNDUP(72.000,2) = 72.00
The screenshot below shows that this is not what is happening for me.
It's rounding up 72.000 to 72.01. In the screenshot, the error fields are circled in red. The original total hours are in the right most field and the rounded hours are on the left field "(Total Hours Rounded ,2)"
Any help is appreciated for this.
Solved! Go to Solution.
Aug 09, 2023 03:31 PM
It seems that ROUND is a complex calculation and is prone to fractions.
How about adding a FLOOR?
ROUNDUP(FLOOR({Total Hours},0.001),2)
Aug 09, 2023 11:48 AM
Even though it's not visible, there is a 1 somewhere at the end (after 8 decimal spots) in the total hours field. If you change the formula in the total hours field to ROUND(YOUR EXISTING FORMULA,8), it should fix this.
Aug 09, 2023 01:54 PM
Hey Ron, thank you for the message.
I'm sure all the numbers that we are adding together only go to 3 decimal places. Not to mention you can even see the sum here at the bottom only goes to 3 decimal places. It doesn't make sense for this to break for multiple records..
I will try your suggestion.
Aug 09, 2023 03:31 PM
It seems that ROUND is a complex calculation and is prone to fractions.
How about adding a FLOOR?
ROUNDUP(FLOOR({Total Hours},0.001),2)
Aug 10, 2023 07:15 AM
Thanks Sho! This worked for me.