Operators for Calculated Fields

Basic calculations

Name	Operator	reverse polish notation example	what it does	Starting with Version

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

Name	Operator	reverse polish notation example	what it does	Starting with Version

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

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

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