4D v13.4

SUM

Home

 
4D v13.4
4D SQL Reference
Functions
SUM

SUM  


 

 

Command SUMSUM ([ALL |DISTINCT] arithmetic_expression)

The SUM function returns the sum of the arithmetic_expression. The optional ALL and DISTINCT keywords are used to respectively retain or eliminate any duplicate values.

Example  

This example returns the sum of the expected sales less the sum of the actual sales, as well as the minimum and maximum value of the actual sales multiplied by 100 and divided by the expected sales for the SALES_PERSONS table:

SELECT MIN ( ( SALES * 100 ) / QUOTA ),
MAX ( ( SALES * 100 ) / QUOTA ),
SUM ( QUOTA ) - SUM ( SALES )
FROM SALES_PERSONS

 
PROPERTIES 

Product: 4D
Theme: Functions

 
INDEX

Alphabetical list of commands

 
SEE ALSO 

AVG
COUNT