Weights

The weight property controls how a child member rolls up to its immediate parent, whether that child is also a parent of another consolidation or a leaf member. Top level consolidations do not have a weighting.

Weight only applies to numeric members. The default weight for a member is 1, this gives a member a positive value. Weight can be used to change a positive value to a negative value, often -1. For example, if the unit price for a product is EUR 50 and the discount is EUR 5, apply a weight of -1 to the discount member. Applying a weight keeps the addition result logical.

You can also weight members as zero to keep them out of a total. For example, say you have a consolidation member called Drivers, and this is made up of Floorspace, Headcount, and Population growth. You would weight Floorspace, Headcount, and Population growth as zero because it makes no sense to add them together.