DuplicateWeight Property

The DuplicateWeight property sets or returns the name of the measure that contains weighting factors.

Syntax

Measure .DuplicateWeight

Applies To

Measure Object

Discussion

Use this property to return a weighted average for the rollup measure instead of a true average. The weighted average of measure A, which uses measure B as a weight, is calculated using an equation similar to the following:

∑(Ai * Bi) / ∑Bi

The measure that is rolled up must be set to trDuplicateRollupAverage.

Type

String

Access

Read/Write

Examples

objMeasures = objModel.MeasurescurrentMeasure = objMeasures("Revenue")currentMeasure
currentMeasure.DuplicateWeight = objModel.Measures("Quantity").Name