Gross profit
Gross margin
Variance
Variance percentage
Previous-period change
Total across a dimension
Share of total
Revenue follows the current segment, this produces each department’s share when calculated by Department.
Formula guides
Common formula patterns
Reuse supported examples for margins, variances, previous periods, segment totals, rolling windows, forecasts, and date boundaries.
These patterns use supported formula syntax. Replace the example Variable and dimension names with names from your model.
At monthly grain, this compares the current month with the previous month.
Because the plain
The range includes the current month and the preceding 11 months.
Assign the formula to Forecast when Actuals should continue to reflect imported data.
The same result can also be expressed as:
Before saving a pattern, confirm its target Variable, scope, Date grain, formula range, and Scenario.