DE.WEIGHT

When you define a consolidated element, you can assign a weight to each of its components. Elements are multiplied by their weight factor before consolidation. The value of a consolidated element is always the sum of the values of the elements it contains. Because weights can be positive or negative numbers, simple subtraction can be achieved.

For example, the Net Revenue element of the Profit dimension in the Best Practices OLAP database has two child elements: Revenue and Sales Deduction. Revenue has a weight of 1 and Sales Deduction has a weight of -1.

DE.WEIGHT returns the consolidation weight of a specified component of an element.

Syntax

DE.WEIGHT(Database alias,Dimension,Parent,Child)

Dimension is the name of the dimension which contains the element in question, Parent is the parent and Child is the child.

This formula returns -1, the weight of the Sales Deduction element:=DE.WEIGHT(B25,"Profit","Net Revenue","Sales Deduction")

Arguments to this function can be strings, or references to cells containing strings. If strings, they must be enclosed in quotes.

If an element does not exist or is not a member of Dimension, the function returns a #Value error.