Summarize

The functions of this category calculate a single value using a whole property specified as its parameter. Besides the property name, any expression can be used. In this case, a temporary property is created in accordance with a typed expression, and this property will be used as a function parameter.

Name Generated expression Description Expression example Ex

pmin

pmin(property)

pmin( property, logical expression )

pmin(property1, property2,
..., logical expression)

Find minimum property value using an optional  logic filter.

pmin($P$)

pmin($P$,  $LayerId$ = 0)

55

pmax

pmax(property)

pmax(property, logical expression)

pmax(property1, property2,
..., logical expression)

Find maximum property value using an optional  logic filter.

pmax( $P$,  $LayerId$ = 0)

pmean

pmean(property)

pmean(property, logical expression )

pmean(property1, property2, ..., logical expression)

Find mean property value using an optional  logic filter.

pmean( $P$,  $LayerId$ = 0)

pmedian

pmedian(property)

pmedian(property, logical expression)

pmedian (property1, property2,
..., logical expression)

Find median property value using an optional  logic filter.

pmedian( $P$,  $LayerId$ = 0)

pstddev

pstddev(property)

pstddev( property, logical expression)

pstddev(property1, property2,
..., logical expression)

Find standard deviation for property using an optional logic filter

pstddev( $P$,  $LayerId$ = 10)

paverage

paverage(property, weight property)

paverage(property, weight property, logical expression)

Find weighted average value for property using an optional logic filter.

paverage( $P$,
$Cell Volume$,
$LayerId$ = 2)

psum

psum(property)

psum( property, logical expression)

psum(property1, property2,
..., logical expression)

Find sum of property values using an optional logic filter.

psum( $P$,  $LayerId$ < 5)

56, 57

Only those values of the property are used for calculation, which produce a true result for logical expression. Parameter logical expression is not obligatory. If it is absent, then all property values are used.

EXAMPLE: Expression psum($Cell Volume$,$LayerId$== 1) gives the volume of layer with identification equal to 1. Expression psum($Cell Volume$) gives the volume of the whole grid.

Summarized functions can also be used with several properties. For example, expression pmean($Property1$, $Property2$, …, logical expression) gives the mean value for several properties, but in this case the parameter logical expression is obligatory.  

Example 55 Property scale. Example to scale a property between interval [0, 1]

Original    click to enlarge

($M2$ - pmin($M2$ ))/ (pmax($M2$ ) - pmin($M2$ ))    click to enlarge

 

Example 56 Calculate volume of corresponding layer

psum( $Cell Volume$ , $LayerId$ = 15)