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 |
Calculation formula used,
Avg (DISTINCT "W_DAILY_REV_DFT_F"."Actual Sum")
AVGDISTINCT FUNCTION IN OBIEE11g |
Check In the Results Area.
AVGDISTINCT FUNCTION IN OBIEE11g |
Comments
Post a Comment