- Type: Inserted as a measure
- Description: Returns only the integer part from a division, discarding the remainder.
- Range:
- Columns: Each column
- Rows: Each row
- Measures: First measure
- Syntax:
div(sum(0, 0, m1); 3)
- Parameter examples:
- div(7; 3) = 2
- div(7; 4) = 1
- div(-7; 3) = -2
- div(-7; -3) = 2
Notice: You can manually replace the default value "3" with any other value. It can even be replaced by a full calculation expression, e.g. div(sum(0, 0, m1); sum(0, 0, m2))
- Sample crosstab:
Example
In the sample crosstab above, we would like to calculate the integer division (by 3) from the numbers in each column.
Adding the calculation as a measure, we get this result:
Comments
Please sign in to leave a comment.