CEIL, Ceiling value (as a column)

  • Type: Inserted as a column
  • Description: Returns the nearest integer value higher than or equal to a number.
  • Range:
    • Columns: Last column
    • Rows: Each row
    • Measures: First measure
  • Syntax:
ceil(sum(d-1, 0, m1))
  • Sample crosstab:

 

Example

In the sample crosstab above, we would like to calculate the ceiling values from the numbers in last column.

Adding the calculation as a column, we get this result:

Was this article helpful?
0 out of 0 found this helpful

Comments

0 comments

Please sign in to leave a comment.