@VARPER
The @VARPER calculation function for Essbase 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 and those that are non-expense, and calculates the variance accordingly.
Syntax
@VARPER (mbrName1, mbrName2)
Parameters
- mbrName1 and mbrName2
-
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.
Example
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 non-expense, whereas COGS is expense. This example produces the following report:
Year Product Market
Sales COGS
===== ====
Actual 400855 179336
Budget 373080 158940
Variance % 7.4 (12.8)
See Also