This section defines the mathematical functions available for creating formulas for form formula rows and columns. To insert formula rows and columns in forms, see Adding Formula Rows and Columns.
The syntax for mathematical functions:
FunctionName(arguments)
Table 47. Mathematical Function Syntax
Variable | Description |
|---|---|
FunctionName | The name of a mathematical function |
arguments | A numeric value, a row, column, or cell reference, or an embedded function |
Table 48. Mathematical Functions
Function | Description |
|---|---|
Abs | Returns the absolute value of numeric values or references |
Average | Returns the average of a group of numeric values or references |
AverageA | Returns the average of a group of numeric values or references. The calculation includes #MISSING cells only for rows or columns that are not suppressed. |
Count | Returns the number of values in a group of numeric values or references |
CountA | Returns the number of values in a group of numeric values or references. The calculation includes #MISSING cells only for rows or columns that are not suppressed. |
Difference | Returns the absolute value of a numeric value or reference subtracted from another numeric value or reference |
Eval | Evaluates an expression. Eval is useful for embedding expressions as function arguments |
IfThen, If | Returns one value if a condition equals true, and another value if a specified condition equals false |
Max | Returns the maximum value from a group of numeric values or references |
Min | Returns the minimum value from a group of numeric values or references |
Mod | Returns the remainder, modulus, from a division formula |
PercentOfTotal | Returns the result of a numeric value or reference divided by another numeric value or reference, multiplied by 100 |
Pi | Returns the number 3.14159265358979, to 15 digits |
Product | Multiplies all numbers or references and returns the product |
Random | Returns a random number between 0.0 and 1.0 |
Rank | Returns the highest or lowest value of a specified column or row |
Round | Rounds a number up or down by specified digits |
Sqrt | Returns the square root of a numeric value, row, column, or cell |
Sum | Returns the sum of a group of numeric values or references |
Truncate / Trunc | Removes the specified number of digits from numeric values |
Variance / Var | Evaluates the difference between the specified values based on the account type for the current account |
VariancePercent / VarPer | Evaluates the percentage difference between the specified values based on account type for the current account |