## Calculating Variances with Negative Numbers

A common metric in dashboards and reporting is variance calculation, i.e. comparing a particular data point against a target or previous data point to find the delta.For example, if you have a target of 100, and an actual of 67, then the variance would be -33%. In other words, the Actual is 33% less than the Target.The standard