Variance calculations
Variance calculations are common calculations in all financial, sales, and other types of applications that compare different sets of data. For example, the calculation might compare current results with those of a prior year, or compare results from an Actual scenario to a Budget scenario.
In This Section
- Variance to last year template
Calculates the difference between values in the current year and values from the previous year.
- Variance to previous period template
Calculates the difference between values in the current period and the prior period, and determines whether the difference is favorable or unfavorable.
- Percent variance to previous year template
Calculates the percent of variance between values in the current period and values in the same period of the previous year.
- Percent variance to previous period template
Calculates the percent of variance between values in the current period and values in the prior period.
- Variance between two scenarios template
Calculates the variance between two different scenarios, and determines whether the difference is favorable or unfavorable.
- Percent variance between two scenarios template
Calculates the percent of variance between two different scenarios, and determines whether the difference between scenarios is favorable or unfavorable.
Related Sections
- Predefined templates for general business rules
Describes the elements of a predefined rule template.
- Filling a placeholder in a rule template
Provides step-by-step instructions for filling the placeholders in a rule template.
- Script to create dimension members for rule templates
Provides reference information about a script that Planning Server includes to create dimension members that are required by predefined templates.