VariancePercent Behavior

VariancePercent expects comparison of the same account type. When you compare two different account types, like Sales and 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 results in #error, unless specified differently using ifnonnumber property.