AVG
Usage
Use this function to return the average value of a given column. You can apply a restriction or include null values or not with a boolean condition (true / false)
Category | Function | Type | Where to use | Argument statement |
---|---|---|---|---|
FUNCTION | SERVER STORAGE | LOGICAL | .VALUE |
Syntax
1 |
|
Arguments
#Storage
the storage entity name
#Storage.Counted_Column
the column whose items would be count
#Storage.Condition_Column (optional)
the column field to check the restriction condition
Value (optional)
any cell value (#Storage_Name.Field_Name.VALUE
or .OLDVALUE
), constant, System Variables or function-returned value
true / false (optional)
true to include NULL values, false to exclude NULL values
Return Value
Decimal
Examples
Example 1
Formula
=AVG(
#StorageExample;
#StorageExample.Amount;
#StorageExample.Quantity == 1;
false
)
Description Return the average value of column Amount of StorageExample where Quantity of StorageExample is 1 and exclude NULL values
Result Average value depending on the Quantity