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

Tips Recipes Brio 2002

(Multi-contingency Grouping Columns continued)

1) In the Results section, add a new Computed Item. Call it Program Cycle, and define its

formula as follows:

if (Budget_Year <= '1966') { 'Old Cycle'

} else {

if (Budget_Year <= '1971') { '1967-1971'

} else {

if (Budget_Year <= '1976') { '1972-1976'

} else {

if (Budget_Year <= '1981') { '1977-1981'

} else {

if (Budget_Year <= '1986') { '1982-1986'

} else {

if (Budget_Year <= '1991') { '1987-1991'

} else {

if (Budget_Year <= '1996') { '1992-1996'

} else {

if (Budget_Year <= '2000') { '1997-2000'

} else {

if (Budget_Year <= '2003') { '2001-2003'

} else {

if (Budget_Year <= '2006') { '2004-2006'

} else {

if (Budget_Year <= '2009') { '2007-2009'

} else {

'Future Cycle' } } } } } } } } } } }

Note that the first and last entries in this formula create the ceiling and floor

contingencies. You can create more complex contingency scenarios by using multiple

measures in the nested If-Then-Else logic.

2) Use this new column as a dimension label for your Pivots, Charts and Reports.

1 2 ... 21 22 23 24 25 26 27 28 29 30 31 ... 77 78

Pas de commentaire

Component Solution Services REC02F Manuel d'utilisateur Page 26