- Type: Inserted as a column
- Description: Returns only the remainder from a division.
- Range:
- Columns: Last column
- Rows: Each row
- Measures: First measure
- Syntax:
mod(sum(d-1, 0, m1); 3)
- Parameter examples:
- mod(7; 3) = 1
- mod(7; 4) = 3
- mod(-7; 3) = -1
- mod(-7; -3) = 1
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. mod(sum(d-1, 0, m1); sum(d-1, 0, m2))
- Sample crosstab:
Example
In the sample crosstab above, we would like to calculate the mod 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.