Aggregate functions syntax

See the aggregate functions syntax in the example of the Sum function:

Sum(expression)

Sum(band, expression)

SumIf(band, expression, condition)

expression – expression for calculation;

band – a name of a band for calculation;

condition – a condition of inclusion of an expression into the calculation.

When you calculate an aggregate function on a page or container, you should write a letter “c” first and then the aggregate function name. See the sample:

cSum(expression)

cSum(band, expression)

cSumIf(band, expression, condition)

For calculation of totals of a container you should write col first and then the aggregate function name:

colSum(expression)

colSum(band, expression)

colSumIf(band, expression, condition)

The Count function has a distinguishing feature from other aggregate functions. It does not have an expression for calculation. Syntax of this function see below.

Count()

CountIf (condition)

Count (band)

CountIf(band, condition)

cCount ()

cCount (band)

cCountIf(band, condition)

colCount ()

colCount (band)

colCountIf(band, condition)

Important! If you use the C# programming language all aggregate functions always check the register.