Setting up formula fields

Each report field in a template has an ID that can be set by the user.

The ID field has the following default value: “Field_[form_field_id] for example “Field_1”

You can change the ID to a value of your choice.

It’s the content of the ID field that must be referenced when inserting formulas in the Formula value of a formula field.

You can for example calculate the sum of three fields like this: Field_1 + Field_2 + Field_3

It’s important, of course, that you ensure that the fields you reference in a formula are number fields.

Besides simple mathematical operators like +, -, * and / you can use the following mathematical functions in your formulas:

Method

Description

abs(x)

Returns the absolute value of x

acos(x)

Returns the arccosine of x, in radians

asin(x)

Returns the arcsine of x, in radians

atan(x)

Returns the arctangent of x as a numeric value between -PI/2 and PI/2 radians

atan2(y,x)

Returns the arctangent of the quotient of its arguments

ceil(x)

Returns x, rounded upwards to the nearest integer

cos(x)

Returns the cosine of x (x is in radians)

exp(x)

Returns the value of Ex

floor(x)

Returns x, rounded downwards to the nearest integer

log(x)

Returns the natural logarithm (base E) of x

max(x,y,z,...,n)

Returns the number with the highest value

min(x,y,z,...,n)

Returns the number with the lowest value

pow(x,y)

Returns the value of x to the power of y

random()

Returns a random number between 0 and 1

round(x)

Rounds x to the nearest integer

sin(x)

Returns the sine of x (x is in radians)

sqrt(x)

Returns the square root of x

tan(x)

Returns the tangent of an angle

 

You can also use the following constants in your formulas:

E

Returns Euler's number (approx. 2.718)

LN2

Returns the natural logarithm of 2 (approx. 0.693)

LN10

Returns the natural logarithm of 10 (approx. 2.302)

LOG2E

Returns the base-2 logarithm of E (approx. 1.442)

LOG10E

Returns the base-10 logarithm of E (approx. 0.434)

PI

Returns PI (approx. 3.14)

SQRT1_2

Returns the square root of 1/2 (approx. 0.707)

SQRT2

Returns the square root of 2 (approx. 1.414)

 

Please note that constants must be referenced as Math.[constant]. For example Math.E or Math.LOG10E.

 

Examples

The square root of the value in Field_1 can be found like this: sqrt(Field_1)

The highest value out of three different values: max(Field_1, Field_2, Field_3)