
Contributor III
2021-12-23
12:32 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
How can I force a decimal value to round up to the next whole number for all values
Good day -
I have a need for an expression that allows me to round up to the next whole number as long as the decimal value is greater than .0. Currently, the ROUND() function will round down if less than 0.5 and up otherwise (using a step of 1.0).
Is there a way for force the rounding to go upwards in all cases?
I am doing a date difference, and want to show a whole day in any cases where the actual date difference is less than 1.0.
Thanks,
Mitchell
3,345 Views
1 Solution
Accepted Solutions

Specialist III
2021-12-23
04:13 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Check the Ceil function
2 Replies

Specialist III
2021-12-23
04:13 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Check the Ceil function

Contributor III
2021-12-29
10:03 AM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thanks - this did the trick!
3,213 Views
