Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Roundup Formula Error

Topic Labels: Formulas
1492 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Leno_Marin
5 - Automation Enthusiast
5 - Automation Enthusiast

I’m trying to ROUNDUP() the value of a “Wall Width” / “Usable Roll Width” but I’m getting an error in the formula. See screenshot here: UGH why can’t I upload a screen shot!!

t’s a very straight forward formula and I can’t figure out why it’s not rounding up to 4, in this case.

1 Reply 1

@Leno_Marin what does your formula look like? Can you post it here surrounded by three backticks on either side (```) so we can see what you have in the ROUNDUP() function?

Are you making sure to provide a precision value to the function? If you want to round to a whole integer, like 4, you’ll want to provide 0 as the precision value:

ROUNDUP({Wall Width} / {Usable Role Width}, 0)