Component Solution Services REC02F Manuale Utente Scaricare il pdf (Pagina 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

Nessun commento

Component Solution Services REC02F Manuale Utente Pagina 26