Component Solution Services REC02F Manuel d'utilisateur télécharger pdf (Page 54)

Tips Recipes Brio 2002

(Fact-based Delta Trends continued)

The formula’s logic is as follows. If dollar amounts exist for both years, perform a normal %

change calculation (i.e., (Current-Previous)/Previous ). If an amount exists for the prior year

but not the following year, tag that as a delta of –100%. If no amount exists for the prior

year but one exists for the following year, tag that as a delta of +100%.

4) Add a final Computed Item to calculate the average delta across the entire range of years.

In our example, name it Avg_ Annual_Chg, and define its formula as:

( Chg_1993 + Chg_1994 + Chg_1995 + Chg_1996 + Chg_1997 +

Chg_1998 + Chg_1999 + Chg_2000 ) / 8

5) Select the Avg_Annual_Chg column, right-click on it and change the numeric display to be

0.00%.

6) With the Avg_ Annual_Chg column still selected, open the Spotlighter and define the

appropriate highlight definition. For example, say we wanted to highlight any average

change greater than 10%, you would define the Spotlighter as shown below:

Remember that Spotlighter values are defined in terms of the “raw” unformatted numbers.

Therefore, you need to enter the target value as 0.1 (the raw equivalent of 10%).

1 2 ... 49 50 51 52 53 54 55 56 57 58 59 ... 77 78

Pas de commentaire

Component Solution Services REC02F Manuel d'utilisateur Page 54