Trace:

Differences

This shows you the differences between two versions of the page.

--- expression function - mod [2016/09/14 18:19]
+++ expression function - mod [2016/09/14 18:19] (current)
@@ Line 1: / Line 1: @@
+====== Mod(Expression Function) ======
+===== Purpose =====
+The **Mod** function (MOD) is used obtain the remainder of the division of one number by another.
+{{::mod_initial.png?direct&600|}}
+===== Parameters =====
+The **Mod** function has two required parameters:
+==== Numerator ====
+Allowed Inputs: [[Field|field]] value or number
+The first required parameter is the number that represents the numerator of the division operation. Either use the use the [[Query Builder]] to choose a field that contains the value or use type a value to enter a number.
+==== Denominator ====
+Allowed Inputs: [[Field|field]] value or a number
+The second required parameter of the **Mod** function is the number that represents the denominator of the division operation. 0 is an illegal value for the denominator. Either use the query builder or the type a value option to enter a number.
+===== Output =====
+The output of the **Mod** function is a number representing the remainder of the division operation.
+===== Example =====
+For example MOD(8,3) would result in 2.

expression function - mod.txt · Last modified: 2016/09/14 18:19 (external edit)