You can test for #MISSING values in a database. See Consolidating #MISSING Values.
Assume that a database outline contains a member called Commission. Commission is paid at 10% of sales when the Sales value for the current member combination is not #MISSING. When applied to a Commission member in the database outline, the following formula calculates Commission:
IF(Sales <> #MISSING) Commission = Sales * .1; ELSE Commission = #MISSING; ENDIF;
If you place the formula in a calculation script, you must associate it with the Commission member as shown:
Commission(IF(Sales <> #MISSING) Commission = Sales * .1; ELSE Commission = #MISSING; ENDIF;);
Essbase cycles through the database, performing the following calculations: