Variance is a financial function that evaluates the difference 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 Essbase Cloud, Planning details, and Financial Management database connections.
Var(reference1, reference2)
where reference1 and reference2 are references to a row, column, or cell that correspond to members of the same Account dimension whose variance results are to be calculated.