Variance

Settings related to the Variance and its format. Explained in details in Templates articles.


Setting
Description
Mandatory
Variance StyleThe variance style has the following options: Arrow, Background, Bar, BarAndValue, Border, Font, None, TrafficLight, TrendArrow. Default is Font.Yes
Suppress Variance

An overview in which situation the variance will be suppressed, see Variance Threshold for more information

Yes
Variance ThresholdThreshold value for the Variance (e.g., Actual vs. Budget). If the Variance is less than the 1st threshold value, then Red (indicating an unfavorable variance) is used. If the Variance is greater than the 2nd threshold value, then Green (favorable variance) is used. And if Variance is between the 2 threshold values, Orange (neutral variance) is used. Use, for example, -200;300 for absolute thresholds or -10%;20% for relative thresholds.Yes