Differences

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

Link to this comparison view

expression function - mod [2016/09/14 14: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 14:19 (external edit)
Copyright WorkXpress, 2019