Styles

The following options are available for the variance style:

Arrow - an arrow will be displayed colored depending on the VarianceOutcome of the cell. The direction of the arrow is determined by the value of the variance the following way: >0 => arrow up; <0 => arrow down; =0 => arrow down
Background - the back color of the cell will be colored accordingly to the VarianceOutcome of the cell (Positive, Negative, Neutral)
Bar - instead of the numeric value the bar will be shown. It will be colored accordingly to the VarianceOutcome
Bar and Value -both numeric value and a bar will be displayed. The bar will be colored accordingly to the VarianceOutcome
Border - the border color of the cell will be colored accordingly to the VarianceOutcome of the cell (Positive, Negative, Neutral)
Font – the font color of the cell will be colored accordingly to the VarianceOutcome of the cell
None - the numeric value of the variance will be shown and it won’t be colored
TrafficLight - instead of the numeric value the trafficlight will be shown. It will be colored accordingly to the VarianceOutcome
TrendArrow - instead of the numeric value the TrendArrow will be shown. It will be colored accordingly to the VarianceOutcome. The direction of the arrow in the TrendArrow is also determined by the VarianceOutcome the following way: positive => arrow up right; negative => arrow down right; neutral => arrow right.

User can specify variance style per template in the Other Settings and per report the Other Settings.
User can specify the variance style for every List Item with a variance formula. If the variance style is specified in the formula than it overrides report and template setting.

Examples

Below you will find the examples of different variance style being applied to a report:

Example 1: Background variance style

Example 2: Bar variance style

Example 3: Arrow variance style

Browser not supported