- Introduction to WorkXpress
- Building Your Application
- Examples and Best Practices
- Technical Manual
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. |