Calculated Fields - Supported Functions

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


Function
Name & Description


Return Type


Examples

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
ADD(8, 101.4, 10, 20) = 139.4
ADD(NULL, 10, 20, NULL) = 30

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
SUBTRACT(101.4, -8) = 109.4
SUBTRACT(NULL, 10) = -10

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
MULTIPLY(NULL, 10) = NULL
MULTIPLY(10, 10, 10, 1.1234) = 1123.4

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,
DIVIDE(15, 4) = 3.75
DIVIDE(100, 1000) = 0.1
DIVIDE(0, 4) = 0
DIVIDE(15, 0) = NULL
DIVIDE(NULL, 4) = NULL
DIVIDE(15, NULL) = NULL

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
MOD(15, 4) = 3
MOD(100, 1000) = 100
MOD(10, 0.5) = 0
MOD(0, 4) = 0
MOD(15, 0) = NULL
MOD(NULL, 4) = NULL
MOD(15, NULL) = NULL

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
ROUND(100.495) = 100
ROUND(100.5) = 101
ROUND(100.998) = 101
ROUND(-100.495) = -100
ROUND(-100.5) = -100
ROUND(-100.998) = -101
ROUND(NULL) = NULL

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
FLOOR(10.8) = 10
FLOOR(-10.8) = -11
FLOOR(NULL) = NULL

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
CEILING(10.8) = 11
CEILING(-10.8) = -10
CEILING(NULL) = NULL

value: Initial value

Numeric

Yes

No

Need support? Create a request with our support team.

Copyright © 2005 - 2025 Appfire | All rights reserved.