CEIL

Description

CEIL returns the value of the given parameter, always rounded up to the nearest whole number.

‚Äč

Example

CEIL(p.total_fee)

This expression returns the total fee that applies to a person, always rounded up to the nearest whole number, even if the decimal value is under .50.

If the total fee for a client comes out at USD 267.32, CEIL(p.total_fee) will return USD 268.