The VariancePercent function expects comparison of the same account type. When you compare two different account types, like Sales & Expense, the VariancePercent function performs the straight math without applying the logic of the account type. For example:
In Oracle Essbase and Planning Details, when the VariancePercent function is applied to a dimension that is not “Accounts” type, an #error results at runtime.
#missing is treated as zero (0), unless specified differently using ifnonnumber property.
#error is results in #error, unless specified differently using ifnonnumber property.