Reference Property Arguments

A reference property argument specifies how to treat formula reference results and is used in conjunction with the other properties.

There is one reference property argument: IfNonNumber/IFFN.

IfNonNumber specifies a replacement for #Missing and #Error values with a specific numeric value.

The syntax is:

AXIS[segment(range)].IfNonNumber(arg).AggregateProperty

Table 11-2 Argument Components

Argument	Description
`AXIS`	(Optional) A row, column, or cell keyword.
`Segment(range)`	Any axis reference, such as a row number or column letter.
`IfNonNumber`	How to treat missing or error data within the `AxisRef.`
`(arg)`	What number to use if missing or error data is encountered within the `AxisRef`.
`AggregateProperty`	(Optional) The aggregate function used for aggregate segments. See Aggregate Property Arguments.

For example:

If cell[1,A] = 3 and cell[1,B] = #Missing,

The following expression returns #Error:

  cell[1,A] / cell[1,B]

The following expression replaces cell[1,B] with 1 and returns 3:

  cell[1,A] / cell[1,B].ifNonnumber(1)

Note:

If you use suppression for #Missing or #Error in a grid, and the grid contains a formula row or column that uses the IfNonNumber property, #Missing and #Error remain suppressed.

Note:

When using a Oracle Hyperion Financial Management database connection, and the MissingValuesAreZeroInFormulas (formerly MissingValuesAreZeroInFormulasInHFM) option in JConsole is set to one (1), the #Missing value is zero regardless of the setting of the IfNonNumber property. However, if the file is set to zero, the IfNonNumber property behaves as described. (For information on JConsole, see the Oracle Hyperion Financial Reporting Administrator's Guide.