Component Solution Services REC02F User Manual download 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

No comments

Component Solution Services REC02F User Manual Page 26