The Calculated field allows you to calculate a value based on the values that have been selected in the form.
A technical implementation can be very complex if you enable brackets in the algorithm.
For example,
((2 * (a + b)) + 5) / 3
is readable. However, it can be difficult to process.
This representation (in reverse Polish notation or postfix), on the other handa b + 2 * 5 + 3 /
can be processed relatively easily and is also readable for an experienced person.
For longer formulas (or calculation instructions), readability can be greatly impaired. For this reason, multi-line and structural commands have been supported since April 15, 2024.
A field consists of:
a single-line expression which can contain these operators. Operators for Calculated Fields
or a multi-line structure which is described here.
Here are some example templates: