Editing the Formula of a Column
Before you start
You must have one of the following user type
permissions:
BI Author Limited
BI Author Developer
BI Tenant Administrator
Here's what to do
- Navigate to the analysis.
- Edit the analysis.
- In the Selected Columns pane, click the Options button beside the column whose formula you want to edit and select Edit Formula.
- Use the Edit Column Formula dialog: Column Formula tab to perform various tasks such as creating customized headers and creating or editing the formula for the column. You can build a simple mathematical formula using operator and character buttons, such as "Base Facts"."1-Revenue"*1.10. You can click the Variable button to create and use a global variable to maintain a value that may need to be changed during the course of business across multiple analyses. You create a global variable as part of the process of creating an analysis. For example, you can create a global variable for the start of the fiscal year and change it as necessary for the start of each new fiscal year.
- Optionally, use the Edit Column Formula dialog: Bins tab to combine values for the column into sets.
- Click OK.
Results:
The column formula is saved with the analysis in which it is used.