Operation Results on #MISSING and Zero Values

If a data value does not exist for a unique combination of members, Essbase gives the combination a value of #MISSING. A #MISSING value is different from a zero (0) value. Therefore, Essbase treats #MISSING values differently from 0 values.

The following tables shows how Essbase calculates #MISSING values. In this table, X represents any number.

Table 3-4 How Essbase Calculates Missing Values

Calculation/Operation	Result
X + `#MISSING`	X
X – `#MISSING` `#MISSING` – X	X -X
X * `#MISSING`	`#MISSING`
X / `#MISSING` `#MISSING` / X X / 0	`#MISSING` `#MISSING` `#MISSING`
X % `#MISSING` `#MISSING` % X X % 0	`#MISSING` `#MISSING` `#MISSING`
X == `#MISSING`	False, unless X is `#MISSING`
X != `#MISSING` X <> `#MISSING`	True, unless X is `#MISSING` True, unless X is `#MISSING`
(X <= `#MISSING`)	(X <=0)
(X >= `#MISSING`)	(X >=0) or (X == `#MISSING`)
(X > `#MISSING`)	(X > 0)
(X < `#MISSING`)	(X < 0)
X AND `#MISSING`: 1 AND `#MISSING` (1 represents any nonzero value) 0 AND `#MISSING` `#MISSING` AND `#MISSING`	`#MISSING` 0 `#MISSING`
X OR `#MISSING`: 1 OR `#MISSING` (1 represents any nonzero value) 0 OR `#MISSING` `#MISSING` OR `#MISSING`	1 `#MISSING` `#MISSING`
IF (`#MISSING`)	IF (0)
f (`#MISSING`)	`#MISSING` for any Essbase function of one variable
f (X)	`#MISSING` for any X not in the domain of f, and any Essbase function of more than one variable (except where specifically noted)