Count & CountDistinct

Count: Calculate number of rows having a not null value for the expression

Syntax: COUNT(expr)

Syntax description

expr is any expression(Column)

Steps: Go to Criterial – Select the Column – Right Click – Select Edit Formula – Click on Insert function – click on Aggregate folder and select Count

Example: Count("Sales"."Rp Revenue")

CountDistinct: Calculate number of unique rows having a not null value for the expression

Syntax: COUNT(expr)

Syntax description

expr is any expression(Column)

Steps: Go to Criterial – Select the Column – Right Click – Select Edit Formula – Click on Insert function – click on Aggregate folder and select CountDistinct

Example: Count(DISTINCT "Sales"."Rp Revenue")