Avg and Avg(distinct)

Avg : Average refers to the sum of numbers divided by count of those numbers

Syntax: Avg(expr)

Syntax description

expr is any expression that evaluates to a numerical Values

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

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

=================================================================

Avg(distinct) : Average refers to the sum of only unique numbers divided by count of those unique numbers

Syntax: Avg(DISTINCT expr)

Syntax description:Distinct expr is any expression that evaluates only unique numerical Values

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

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