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.