Consolidate Formula

The Consolidate Formula object references to a formula which is part of a dimension. A formula can contain items and tree items of the selected dimension. It is also possible to define sums. These sums are very flexible and ofter used for KPIs.

Sums are using spread sheet like functions. In this sample the values of the regions North and West are added. It is not necessary that the used items and tree items are included in the Consolidate Formula.

Creating and Editing

It is recommended to use the Assistant to create a new Consolidate Formula. After creation the Fields can be edited.

See Also

• Consolidate Formula Properties