4D v17.4
entitySelection.sum( )
- 4D Language Reference
-
- ORDA - EntitySelection
-
- entitySelection.{attributeName}New
- entitySelection.lengthNew
- entitySelection.queryPathNew
- entitySelection.queryPlanNew
- entitySelection[index]New
- entitySelection.or( )New
- entitySelection.orderBy( )New
- entitySelection.drop( )New
- entitySelection.query( )New
- entitySelection.add( )New
- entitySelection.isOrdered( )New
- entitySelection.minus( )New
- entitySelection.first( )New
- entitySelection.last( )New
- entitySelection.toCollection( )New
- entitySelection.contains( )New
- entitySelection.and( )New
- entitySelection.sum( )New
- entitySelection.count( )New
- entitySelection.min( )New
- entitySelection.max( )New
- entitySelection.slice( )New
- entitySelection.distinct( )New
- entitySelection.average( )New
- Create entity selectionNew
- USE ENTITY SELECTIONNew
entitySelection.sum( )
The entitySelection.sum( ) method returns the sum for all attributePath values in the entity selection.
entitySelection.sum( ) returns 0 if the entity selection is empty.
The sum can only be done on values of number type. If the attributePath type is object, only numerical values are taken into account for the calculation (other value types are ignored). In this case, if attributePath leads to a property that does not exist in the object or does not contain any numeric values, entitySelection.sum( ) returns 0.
An error is returned if:
- attributePath is not a numerical or an object attribute,
- attributePath is a related attribute,
- attributePath is not found in the entity selection dataclass.
C_OBJECT($sel)
C_REAL($sum)
$sel:=ds.Employee.query("salary < :1";20000)
$sum:=$sel.sum("salary")
Product: 4D
Theme: ORDA - EntitySelection
4D Language Reference ( 4D v17)
4D Language Reference ( 4D v17.1)
4D Language Reference ( 4D v17.2)
4D Language Reference ( 4D v17.3)
4D Language Reference ( 4D v17.4)
