CEIL, Ceiling value (as a measure)

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

 

Example

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

Adding the calculation as a measure, 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.