Defining Variances Rules.

Set rules for how Jirav identifies Favorable and Unfavorable Variances in Reports & Dashboards

Variance rules are used in Reports & Dashboards to highlight favorable and unfavorable variances. 

To review, delete, modify & add Favorable Variance thresholds, go to Settings ⚙️ and select Variance Rules.

Variance Rules are set per Data Elements, instead of lines, which means that the Variance Rule can be set for whole Revenue Data Element, and not for individual lines in Revenue.
To add a Variance Rule:

1. Click on the "ADD RULE" button
2. Pick the desired Data Element
3. Define the Favorable Trend
4. Save the Variancle Rule by clicking on the "SAVE" button

Favorable Trend setting determines whether an increase or decrease in a value over time is viewed as favorable. The opposite change is considered unfavorable. For instance, a decrease in costs or an increase in revenue is typically seen as favorable.

It is possible to have control with per-account exceptions. To add the exception, click on the next to the Data Element (like Revenue, COGS, etc.) you want to apply the exception and then click on the "Add Exception" [5]:

The next step is choosing the Exception Account [6], defining the Exception Account's Favorable Trend [7] and saving [8]:

In the example pictured above, the rule states that if the calculated variance for Revenue is greater than 0 or 0%, it is considered a favorable variance and will be displayed in green. Conversely, if the variance is less than 0 or 0%, it is classified as an unfavorable variance and will be displayed in red, as pictured below.