Math functions

Various math functions can be inserted into your expression. These math functions can be found in the 'Functions and Variables' area of the Property Calculator.

When you are using a property with multiple realizations or multiple time steps in the Property Calculator, there are two ways to include all realizations/time steps in the expression field. Assuming you have 5 realizations/time steps, and want to calculate e.g. the mean value, use one of the following expressions:

mean($A$[1],$A$[2],$A$[3],$A$[4],$A$[5])
mean($A$[1],…, $A$[5]) (this property calculator syntax requires three (3) dots to address the consecutive range)

Name	Generated expression	Description	Expression example	Ex
abs	abs(property)	Absolute value.	abs($P$)
acos	acos()	Inverse cosine function.	acos($D$)
asin	asin()	Inverse sine function.	asin($D$)
atan	atan()	Inverse tangent function.	atan($D$)
azimuth	azimuth(propertyX, propertyY)	Azimuth of vector with corresponding coordinates.	azimuth($X$, $Y$)	21
ceil	ceil(property)	Smallest integer that is greater than or equal to expression.	ceil($A$)
clip	clip(property, min, max)	Clip value using defined boundaries.	clip($P$, 0, 1)	18
cos	cos()	Cosine function.	cos($D$)
cosh	cosh(property)	Hyperbolic cosine.	cosh($P$)
dip	dip(propertyX, propertyY, propertyZ)	Dip of vector with corresponding coordinates.	dip($X$, $Y$, $Z$)	22
exp	exp()	Exponential function.	exp(2.0)
floor	floor(property)	Largest integer that is less than or equal to expression.	floor($A$)
gmean	gmean(property1, property2, ...)	Geometric mean value.	gmean($A$, $B$, $C$)
hmean	hmean(property1, property2, ...)	Harmonic mean value.	hmean($A$, $B$, $C$)
length	length(property1, property2, ...)	Length of vector with corresponding coordinates.	length($X$, $Y$, $Z$)
ln	ln()	Natural logarithm	ln(10)
log10	log10()	Common logarithm.	log 10(10.0)
max	max(property1, property2)	Maximum value.	max($A$, $B$)
maxu	maxu(property1, property2)	Undefined if one value is null or undefined, else maximum value.	maxu($A$, $B$)
mean	mean(property1, property2, ...)	Mean value.	mean($A$[1],…, $A$[20])	20
median	median(property1, property2, ...)	Median value.	median($A$[1], $A$[2])
min	min(property1, property2)	Minimum value.	min($A$, $B$)	19
minu	min(property1, property2)	Undefined if one value is null or undefined, else minimum value.	minu($A$, $B$)
mod	mod()	Remainder of a division. Alternative syntax is possible.	mod($LayerId$, 10) $LayerId$ mod 10 $LayerId$ % 10
pow	pow()	Power function.	pow($Depth$, 3)
round	round(property)	Nearest integer to expression.	round($A$)
sin	sin()	Sine function.	sin($D$)
sinh	sinh(property)	Hyperbolic sine.	sinh($P$)
sqrt	sqrt()	Square root function.	sqrt($D$)
stddev	stddev(property1, property2, ...)	Standard deviation.	stddev($A$, $B$, $C$)
tan	tan()	Tangent function.	tan($D$)
tanh	tanh(property)	Hyperbolic tangent.	tanh($P$)
truncate	truncate(property)	Discards the fractional part and returns the integer.	truncate($A$)

Example Expression mean($Porosity$[0], $Porosity$[1], $Porosity$[2]) creates the property whose values are equal to the mean of three $Porosity realizations in each location.

Example 18 Clip function