Choose to display variance and percentage variance in data tables in dashboards, and in measure and location boxes in a view. Variance is the difference between the actual and the comparative values for a data or formula measure. The percentage variance is the variance as a percentage of the comparative.
The formula for variance is:
Actual-Comparative
The formula for percentage variance is:
(100/Comparative)*Variance
Variance appears for data and formula measures but not for group measures. A positive variance is always good, and a negative variance is always bad, except with bipolar measures. Negative variances always appear in brackets.
How to enable variance for dashboards
On the toolbar, choose Preferences, and select Show variance and Show percent variances.
How to enable variance in measure and location boxes in a view
In a view, choose Configure View Tree Display, and select Show variance and Show percent variances.
