Component Solution Services REC02F Uživatelský manuál stáhnout pdf (Strana 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

Žádné komentáře

Component Solution Services REC02F Uživatelský manuál Strana 26