- Type: Inserted as a column
- Description: Returns only the integer part from a division, discarding the remainder.
- Range:
- Columns: Last column
- Rows: Each row
- Measures: First measure
- Syntax:
div(sum(d-1, 0, m1); 3)
- Parameter examples:
- div(7; 3) = 2
- div(7; 4) = 1
- div(-7; 3) = -1
- 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(d-1, 0, m1); sum(d-1, 0, m2))
- Sample crosstab:
Example
In the sample crosstab above, we would like to calculate the integer division (by 3) from the numbers in last column.
Adding the calculation as a column, we get this result:
Comments
Please sign in to leave a comment.