Most variance fields are already provided in Calxa but there are occasions where you may need to calculate your own variance such as the variance between your own custom fields.
Variances in Calxa are not simply A minus B or B minus A but instead this is calculated conditionally so negative variances are always an unfavourable variance. Meaning it's favourable for Actual Income to be higher then Budget or Last Year for example, but unfavourable for Expenses to be higher.
In this video we show you how to add this conditional logic to your own variance calculations.
For ease of reference the logic/formula used in this video is as follows. Swap [Actual] & [Budget] for the actual fields used in your template.
Iif([IsCredit] == False, [Budget] - [Actual], [Actual] - [Budget])