Before you begin
You need a target Variable and the Variables it will reference. In this example:- Target Variable: Gross Profit
- Referenced Variables: Revenue and Cost of Goods Sold
1. Open the target Variable
Open Gross Profit and go to its formula editor. The formula belongs to Gross Profit because that is the value it calculates.2. Enter the calculation
Write:3. Choose where it applies
For a first formula, use the broadest appropriate scope so it acts as the default calculation for the Variable. You can add a more specific formula later for a Dimension, a segment, Actuals, or Forecast.4. Check the formula
Before saving, confirm that:- Gross Profit is the target Variable
- Revenue and Cost of Goods Sold are the intended inputs
- The formula applies in the intended Scenario.
- The scope is not more specific than you need
5. Review the result
Open a Table Block that contains Gross Profit. Check a few periods and, if the table is segmented, a few Dimension items. For example, if Revenue is 100 and Cost of Goods Sold is 40, Gross Profit should be 60.Add detail when you need it
Once the default formula works, you can add a more specific formula without changing the default everywhere. Common next steps include:- Calculate Gross Profit differently for one department
- Use a different formula in Forecast
- Reference another period
- Aggregate several Dimension items.
Ask Ari instead
You can also describe the same outcome:Add Gross Profit to this table, calculate it as Revenue minus Cost of Goods Sold, and check the result for the last three months.Ari can add the visible row, save the calculation, and inspect the resulting values.