Calcuations

The data type “Calculation” allows to define mathematical formulas that can include other number attributes of the same field definition as variables. The calculation attribute of a field instance will then present the result, based on the current values of number attributes that are used as variables.

When creating or editing a field definition, add a data attribute of type “Calculation” and enter a mathematical formula. If the current field definition contains other data attributes of type number, you may reference these as variables within your formula by typing the “@” character. You may also add number attributes later on and reference those, too.

The examplary field definition contains three data attributes of type number to store the planned budgets of different departments. To compute the total budget on the fly, we create a calculation that sums up their values.

Mathematical Operators and Constants

You may create complex expressions by using the following operators and constants:

Symbol

Meaning

Example

Symbol

Meaning

Example

+

Addition

1+1=2

-

Subtraction

1-1=0

*

Multiplication

1*1=1

/

Division

1/1=1

^

Power

2^2=4

#

Modulo

3#2=1

log

Logarithmic functions

log10(1000)=3

log2(1000)=9.9

ln

Natural logrithm

ln(2)=0,693

sqrt

Square root

sqrt(4)=2

sin,cos,tan

Trigonometric functions

sin(pi)=0

pi

Pi

3.141

e

Euler

2.718

 

← Back to Field Definitions