SUM
Usage
Use this function to return the arithmetic sum of all values of a given column. You can apply a restriction
| 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
Return Value
Decimal
Examples
Example 1
Formula
=SUM(
#StorageExample;
#StorageExample.Amount;
#StorageExample.Quantity == 1;
)
Description
Return the sum of all values of column Amount of StorageExample where Quantity of StorageExample is 1
Result
Sum values depending on the Quantity