MOD

Returns the remainder after dividing a measure value by a divisor.

Category

Math

Measure

Select a measure name from the list.

Divisor

Type a value for the divisor.

Returns

Data Analyzer calculates MOD for the measure you selected and displays the remainder value in the cross tab.

Example

Calculate the remainder of a revenue measure, divided by 12, returning an integer. If the revenue value is 4763, MOD returns 11.

Copyright Actuate Corporation 2012