- Type: Inserted as a column
- Description: Rounds a value to nearest specified number of decimals.
- Range:
- Columns: Last column
- Rows: Each row
- Measures: First measure
- Syntax:
round(sum(d-1, 0, m1); 0)
- Parameter examples:
- round(235.537; 0) = 236
- round(235.537; 1) = 235.5
- round(235.537; 2) = 235.54
- round(235.537; -1) = 240
Notice: You can manually replace the default value "0" with any other value. It can even be replaced by a full calculation expression, e.g. round(sum(d-1, 0, m1); sum(d-1, 0, m2))
- Sample crosstab:
Example
In the sample crosstab above, we would like to round the numbers in the last column to 0 decimals.
Adding the calculation as a column, we get this result:
Comments
Please sign in to leave a comment.