ISUNDEFINEDCELLVALUE

ISUNDEFINEDCELLVALUE compares the passed value to the default numeric cube value, which is influenced by the presence of the UNDEFVALS declaration in that cube's rule. The function returns 1 if the passed value equals the cube's default value, otherwise the function returns 0.

This function is valid in both rules and TurboIntegrator processes.

Syntax

ISUNDEFINEDCELLVALUE(TestValue, <Cube>)

Arguments

Argument	Description
`TestValue`	The numerical value to compare against the cube's default value.
`Cube`	An optional String argument that specifies the cube whose default value should be compared. When ISUNDEFINEDCELLVALUE is used in a rule, the cube is assumed to be the subject cube unless otherwise specified. When used in a process, a cube should be specified. If the cube is omitted in a process, or is not valid when specified, 0 will be used for comparison.

Argument

Description

TestValue

The numerical value to compare against the cube's default value.

Cube

An optional String argument that specifies the cube whose default value should be compared.

When ISUNDEFINEDCELLVALUE is used in a rule, the cube is assumed to be the subject cube unless otherwise specified.

When used in a process, a cube should be specified.

If the cube is omitted in a process, or is not valid when specified, 0 will be used for comparison.

Example

ISUNDEFINEDCELLVALUE(TestValue) returns 1 when TestValue is the special undefined value and is used in the rule of a cube with UNDEFVALS declared.