Edit Formulas or Calculated Measures
You can fine-tune the columns in an analysis by editing the formulas of columns or editing calculated measures.
Topics:
Edit the Formula for a Column
You can edit the formulas for attribute columns and measure columns when you specify the criteria for an analysis. This editing affects the column only in the context of the analysis and doesn’t modify the formula of the original column in the subject area.
A column formula specifies what the column values represent. In its most basic form, such as "Revenue Metrics"."Revenue", a column takes the data from the data source as is. You can edit the formula to add functions, conditional expressions, and so on. This editing enables you to present analysis results in a variety of ways. For example, you can edit the formula of a Revenue column to display values after a 10% increase in revenue. You can do this by writing a formula that multiplies the Revenue column by 1.1.
Edit Calculated Measures
You can use calculated measures that are derived from other measures and created by using formulas.
For example, you might need to find the value after discounts are taken off the revenue. You create a calculated measure that subtracts the Discounted Amount from the Revenue value.
- Open the analysis for editing.
- On the Results tab, click New Calculated Measure on the toolbar to display the dialog.
- If you have administrator privileges and want to customize folder and column headings with HTML markup, including JavaScript, select Contains HTML Markup, and then enter the HTML markup you want to apply. For examples, see Advanced Techniques: Format with HTML Tags.
- Edit the formula for the calculated measure.
- Click OK.