Calculates the percent variance (difference) between two members. The
variance calculation recognizes the difference between accounts that are tagged
in the database outline as “Expense” or “No Expense” and calculates the variance
@VARPER (mbrName1, mbrName2)
|mbrName1andmbrName2||Members from the same dimension whose variance results are to be calculated.
The percent variance is derived by taking the percent variance of mbrName2 values from mbrName1,
unless an account is tagged as “Expense”, in which case mbrName1 values
are taken as a percent variance of mbrName2.
The following example is based on the Sample Basic database. The percent
variance between Actual and Budget is calculated as follows:
Variance = @VARPER(Actual,Budget);
In this example Sales is defined as “No Expense”, whereas COGS is tagged
as “Expense”. This example produces the following report:
Year Product Market Sales COGS ===== ==== Actual 400855 179336 Budget 373080 158940 Variance % 7.4 (12.8)