AVG (Average)
It calculates the average value of an expression in a result. It must take a numeric expression as its argument. It denotes the mean value of expression.
The denominator of AVG is the number of rows aggregated. For this reason, it is usually a mistake to use AVG(x) in a calculation in Oracle Business Intelligence. Instead, write the expression manually so that you can control both the numerator and denominator (x/y).
Syntax
AVG (numExpr)
Here numExpr is any expression that evaluates to a numeric value.
Look Before using AVG function, only with actual value.
AVERAGE FUNCTION IN OBIEE 11g |
Use the AVG function to calculate the Actual Sum values.
Formula used:
AVG (“W_DAILY_REV_DFT_F”.”Actual Sum”) Actual Sum is the measure column
AVERAGE FUNCTION IN OBIEE 11g |
Check the results, the new calculated AVG Column will calculated automatically and display the AVG values for the revenues.
AVERAGE FUNCTION IN OBIEE 11g |
mkashu.blogspot.in/2013/09/uninstall-obiee-11g-in-windows.html
ReplyDelete