Calculated Fields - Supported Functions
The below table explains in detail the functions that can be used to create calculated fields. The functions are divided into 4 categories
Numeric results in reports, including fractional values returned by functions such as DIVIDE, DAYS, and BUSINESS DAYS, are now shown with up to 4 decimal places instead of 2. The worked examples below still show the older 2-decimal display for illustration; the underlying calculation is unchanged, only the displayed precision is different.
Numeric Functions
For parameters required by the functions,
Is Mandatory?: Indicates whether the parameter is mandatory or not. If the value is mandatory and a value isn't provided for the parameter, the add-on will throw an error
Is Variable Length?: The value 'No' indicates that parameter takes single value. Variable length indicates, the parameter can take multiple values. You can use "Add parameter" link to add more values
|
|
| Parameters | |||
|---|---|---|---|---|---|---|
Name: Description | Type | Is Mandatory? | Is Variable Length? | |||
ADD - Returns the sum of all the numbers given as parameters | Numeric | ADD(8, 101.4) = 109.4 | value1: Initial Value | Numeric | Yes | No |
value2: Value to be added | Numeric | Yes | Yes | |||
SUBTRACT - Returns the difference between provided numbers | Numeric | SUBTRACT(101.4, 1.4) = 100 | value1: Initial value | Numeric | Yes | No |
value2: Value to be subtracted | Numeric | Yes | No | |||
MULTIPLY - Returns the product of all the numbers given as parameters | Numeric | MULTIPLY(10, 1.1) = 11 | value: Initial value | Numeric | Yes | No |
multiplier: Value to be multiplied | Numeric | Yes | Yes | |||
DIVIDE - Returns the quotient after a number is divided by a divisor | Numeric | DIVIDE(15, 3) = 5, | value: Initial value | Numeric | Yes | No |
divisor: Value to divide by | Numeric | Yes | No | |||
MOD - Returns the remainder after a number is divided by a divisor | Numeric | MOD(15, 3) = 0 | value: Initial value | Numeric | Yes | No |
divisor: Value to divide the initial value by | Numeric | Yes | No | |||
ROUND - Returns the value of number rounded to the nearest Integer | Numeric | ROUND(100) = 100 | value: Initial value | Numeric | Yes | No |
FLOOR - Returns the largest Integer value that is less than or equal to the parameter | Numeric | FLOOR(10) = 10 | value: Initial value | Numeric | Yes | No |
CEILING - Returns the smallest Integer value that is greater than or equal to the parameter | Numeric | CEILING(10) = 10 | value: Initial value | Numeric | Yes | No |
