The Calculation Type panel accepts input for the following items for a variance calculation:
Base measure -- Select the measure that you want to subtract from the target measure.
Target measure -- Select the measure that you want to use for comparison with the base measure.
Number Format -- Select one of the default number formats to use for this calculation or choose Options to specify another format.
Options -- Displays the Number Format dialog, in which you can specify a format for the calculation.
This type of calculation applies to measures only.
The formula for this calculation is:
Target-Base
This formula is used to calculate the difference between a base measure and a target for that measure.
An example of this calculation is:
Sales Variance = Sales-Sales Forecast