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