VariancePercent / VarPer

VariancePercent is a financial function that evaluates the difference, in percent, between the specified values based on account type for the current account. For example, for an Income, Flow, Asset, or Balance account, a positive result represents an increase, so the result appears as a positive number. For Expense or Liability accounts, a positive result represents a decrease, so the result appears as a negative number.

This function is available for standard Oracle Essbase, Planning Details, and Financial Management database connections.

For Oracle Essbase: You can use members of an Accounts type dimension that are tagged as "Expense" or "Non Expense".
For Planning Details: In addition to above (Oracle Essbase), you can use the following UDA (User Defined Attributes) Accounts types that are also defined as Asset, Liability, Equity, Revenue, and Expense.
For Financial Management: You can use the following Accounts types: Asset, Liability Income, Expense, Flow, Balance, Balance Recurring.

Syntax:

VarPer (reference1, reference2)

where reference1 and reference2 are references to a row, column, or cell that correspond to members of the same Account dimension whose VariancePercent results are to be calculated.