Totaling When Supporting Detail Cells are Blank

If a data cell in supporting detail is blank, Oracle Hyperion Planning ignores it when aggregating values (instead of assuming that a blank cell means zero).

For example, you might define supporting detail to calculate the daily rate of hiring an instructor ($250) times the number of days per month for which you plan to retain an instructor (4 in January, but none in February). The Instructor total for Feb is 250, even though you do not intend to hire an instructor in Feb, as shown in the following table:

Jan Feb

Instructor

1000

250

Rate +

250

250

Days

4

 

To correctly total values that are aggregated by the * multiplier when some cells are blank, you can leave the Rate cell blank, or enter a zero in the Days data cell, instead of leaving it blank, as shown in the following table:

Jan Feb

Instructor

1000

0

Rate +

250

250

Days

4

0

This causes the rate (250) to be multiplied by 0 (zero), resulting in a value of zero.