VariancePercent Behavior

VariancePercent 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:

Sales	Expense	Result
-400	100	-5.

• #missing is treated as zero (0), unless specified differently using ifnonnumber property.

• #error is results in #error, unless specified differently using ifnonnumber property.