VariancePercent/VarPercent

VariancePercent/VarPercent is a financial function that evaluates the difference, in percent, between the specified values based on account type for the current account.

For Expense accounts, a positive result represents an unfavorable variance, so the result appears as a negative number. For Non-expense accounts, a positive result represents a favorable variance, so the result appears as a positive number.

Variance/Var is available for standard database connections in PBCS, EPBCS, or FCCS.

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