How can I force a decimal value to round up to the next whole number for all values

[joshm43]

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

[jwjackso · Accepted solution]

Check the Ceil function

[joshm43]

Thanks - this did the trick!