AVERAGE FUNCTION IN OBIEE 11g

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