CEILING

Calculates the ceiling of a number. Returns the nearest round number more than or equal to the double/decimal.

Syntax

double? CEILING(double? value)
decimal? CEILING(decimal? value)

Example

CEILING(22.1)

Returns '23'.

or

CEILING(876)

Returns '876'.

You can use this with your column data by entering the column name instead of a fixed number. For example:

CEILING(CostTotal)