✍ Kashif M
Trends

Friday, 13 September 2013


AVG DISTINCT FUNCTION IN OBIEE 11g


By on September 13, 2013


AVGDISTINCT

It calculates the average value of all distinct sale of expression. It will take value as its argument.

Syntax

AVG (DISTINCT numExpr)

numExpr is any expression that evaluates to a numeric value.

It is same as AVG function, here It calculates the distinct value of the revenue.

Before Using the AVG Distinct function
AVGDISTINCT FUNCTION IN OBIEE11g
AVGDISTINCT FUNCTION IN OBIEE11g



Calculation formula used,

Avg (DISTINCT "W_DAILY_REV_DFT_F"."Actual Sum")
AVGDISTINCT FUNCTION IN OBIEE11g
AVGDISTINCT FUNCTION IN OBIEE11g




Check In the Results Area.
AVGDISTINCT FUNCTION IN OBIEE11g
AVGDISTINCT FUNCTION IN OBIEE11g

Kashif
mkashu: AVG DISTINCT FUNCTION IN OBIEE 11g
Review : Kashif | Kashif
Update: September 13, 2013 | Rating: 4.5

Comment for "AVG DISTINCT FUNCTION IN OBIEE 11g"

0 comments

Post a Comment

Blog Archive