Calculation Wizard: Percent variance calculation

The Calculation Type page accepts input for the following items for a percent 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.

This type of calculation applies to measures only.

Formula Description

The formula for this calculation is:

(x-y)/y

This formula is used to return the percent difference between a measure and a target for that measure.

An example of this calculation is:

(Base-Target)/Target

Percent variance between Sales and Quota = (Sales - Quota)/Quota

Suppose that the sales value is 100 and the quota value is 110, which is calculated as follows:

100-110/110 = -9.09%

The percent variance is -9.09%, down relative to the target quota of 110.