| Excerpt |
|---|
Computes the ceiling of a value, which is the smallest integer that is greater than the input value. Input can be an Integer, a Decimal, a column reference, or an expression. |
Numeric literal example:
| D code |
|---|
derive type:single value: CEILING(2.5) |
Output: Generates a column with each row's value 3.
Expression example:
| D code |
|---|
derive type:single value: CEILING(MyValue + 2.5) |
Output: Generates a column containing the smallest integer that is greater than the sum of 2.5 and the value in the MyValue column.
| D code |
|---|
derive type:single value: CEILING(numeric_value) |
| Argument | Required? | Data Type | Description |
|---|
| numeric_value | Y | string, decimal, or integer | Name of column or Decimal or Integer literal to apply to the function |
numeric_value
Name of the column, numeric literal, or numeric expression.
- Missing input values generate missing results.
- Literal numeric values should not be quoted. Quoted values are treated as strings.
- Multiple columns and wildcards are not supported.
| Required? | Data Type | Example Value |
|---|
| Yes | String (column reference) or Integer or Decimal literal | 2.5 |
Example - Exponential functions
| Include Page |
|---|
| EXAMPLE - Rounding Functions |
|---|
| EXAMPLE - Rounding Functions |
|---|
|
