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)