Operators for Calculated Fields
Basic calculations
Name | Operator | reverse polish notation example | what it does | Starting with Version |
---|---|---|---|---|
addition | + | x y + | adds x and y | 2.9.0 |
subtraction | - | x y - | subtracts y from x | 2.9.0 |
division | / or : | x y / | divides x by y | 2.9.0 |
multiplication | * | x y * | multiplies x with y | 2.9.0 |
Advanced calculations
Name | Operator | reverse polish notation example | what it does | Starting with Version |
---|---|---|---|---|
exponentiation | ^ | x y ^ | returns x to the power of y | 2.10.0 |
maximum | $max | x y $max | returns the bigger of x and y | 2.10.0 |
minimum | $min | x y $min | returns the smaller of x and y | 2.10.0 |
Rounding
Note that in order to round to a whole number, y has to be 0. A number smaller than 0 will be treated as 0.
The maximum of decimal points is 10. A number bigger than 10 will be treated as 10.
Name | Operator | reverse polish notation example | what it does | Starting with Version |
---|---|---|---|---|
round | $round | x y $round | rounds x to the yth decimal point | 2.10.0 |
round down | $roundDown | x y $roundDown | rounds down x to the yth decimal point | 2.10.0 |
round up | $roundUp | x y $roundUp | rounds up x to the yth decimal point | 2.10.0 |