NativeAvg

 

Purpose:

Returns the average value.

Parameter:

All                   Field or expression to aggregate.

Boolean         (optional) Filter expression for the field or the expression to be aggregated. Default: True (all data).

Boolean         (optional) Defines that only the unique values should be aggregated (DISTINCT). Default: False.

Return value:

Number

Example:

NativeAvg(Order_Details.Quantity*Order_Details.UnitPrice)