@VARPER

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 accordingly.

Syntax

@VARPER (mbrName1, mbrName2)
Parameter Description

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 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)

See Also