NOTE 💬Traffic Light Variance reporting is an option in the creation of a Dynamic Template in Calxa see the following articles for Dynamic Templates:
Traffic Light variance reporting is a concept where you can use traffic light ratings as a visual indicator on your variances. A simple combination of colours can indicate whether your variances are Unfavourable (Red), On Track (Amber), or Favourable (Green).
In this video we will add a conditional formatting rule to the $ variance column. The actual condition is based on the % variance value. In some reports the % variance column may not be displayed, but as this video shows, you can use any available data, not just that which is in the column you apply the rule to.
Code Snippet
The following code snippet is referenced in the video and can be used to copy into the designer.
Iif(
[RowItemTypeId] == 'Kpi', ?,
[AccountLevel] == ? or ([HasChilds] And [ReportLevel] > [AccountLevel]), ?,
[ReplaceMeWithFieldName] == ?, ?,
[ReplaceMeWithFieldName] > 0.2, rgb(140, 221, 192),
[ReplaceMeWithFieldName] > -0.2, rgb(255, 213, 113),
rgb(252, 179, 179))