Edit Column Formula dialog

Use this dialog to:

• Specify custom text for headings for a column's folder and for a column.

• Specify the aggregation rule for the column totals for an attribute or measure column.

• Edit the formula for an attribute or measure column. A column formula specifies what the column values represent. By editing this formula, you can present analysis results in a variety of ways.

• Create formulas that calculate KPI actual values, target values, and thresholds.

• Create calculated measures.

You cannot customize headings, specify the aggregation rule, or edit the formula for a hierarchical column or for a hierarchy level; however, you can specify a hierarchical column within a formula for an attribute or measure column.

For more information, see:

• "Editing the Formula for a Column"

• "What Are KPIs?"

• "Working with Calculated Measures"

Components

Formula

Use the "Edit Column Formula dialog: Column Formula tab" to customize headings, specify the aggregation rule, and edit the formula for a column.

Bins

Use the "Edit Column Formula dialog: Bins tab" to combine values for the column into sets.