Modulus [Mod]

Return to Complete List of Functions

The Modulus function divides one value by another value and returns the remainder. Parameters ------------------ Value 1       The dividend (numerator) in the calculation. In other words, the value that will be divided. Value 2       The divisor (denominator) in the calculation. The value that the first value is being divided by. Both values can be any combination of raw data, calculated values, or constants. Function Value ------------------------ This function divides the first value by the second value and returns the remainder. This is the same as taking the non-integer portion of the division and multiplying it by the divisor. If the second value is 0, a null value will be returned. Data    Mod(Data,3) -----------------------------------    0.0            0.0    0.5            0.5    1.0            1.0    1.5            1.5    2.0            2.0    2.5            2.5    3.0            0.0    3.5            0.5    4.0            1.0