WAvg (MDX+)

Compute the weighted average value over the specified set, WAvg( Set, Weight, Value ).

Parameters

Name	Type	Cardinality	Default value
set	set-expression	one
weight	value-expression	one
value	value-expression	one

Return

value

Description

The WAvg function calculates the weighted average value of the non-empty cells. Empty cells are ignored.

When the value expression is specified, the measure is evaluated over the set and its weighted average value is returned.

The pseudo code for this algorithm is :


        Weighted Average = WAvg( Set, Weight, Value )

        for each member of the set
        total_weight = total_weight + weight_i
        w_avg = w_avg + weight_i * value_i

        wavg = wavg / total_weight

Examples

WAvg(set,numeric,numeric)

WAvg Amount
383.625

WAvg(set,numeric,numeric) - II

Returns the weighted average of the numeric function applied over the tuples of the set.

In our example we're calculating the weighted average with a variable weight.

Query

WITH
    MEMBER [Measures].[WAvg Amount] AS WAvg( [Geography].[Economy].members, [Measures].[Amount] / 2, [Measures].[Amount] )
SELECT
    [Measures].[WAvg Amount] ON 0
FROM
    [Sales]

Result

WAvg Amount
765.4802867383513

WAvg Amount

765.4802867383513

Assertion : MDX Equals

WITH
    MEMBER [Measures].[weight] AS ( [Measures].[Amount]  / 2)
    MEMBER [Measures].[value] AS ( [Measures].[Amount]  )
    MEMBER [Measures].[WAvg Amount.1] AS Avg( [Geography].[Economy].members, [Measures].[weight]*[Measures].[value] )
    MEMBER [Measures].[WAvg Amount.2] AS Avg( [Geography].[Economy].members, [Measures].[weight] )
    MEMBER [Measures].[WAvg Amount] AS [Measures].[WAvg Amount.1] / [Measures].[WAvg Amount.2]
SELECT
    [Measures].[WAvg Amount] ON 0
FROM
    [Sales]

Special Examples (errors, null, ...)

WAvg(NULL), WAvg({})

XMLA Properties

Find here the value of the XMLA properties when not specified otherwise.