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.