Rule Functions

TM1 Function for Rules – ISUNDEFINEDCELLVALUE

Available In

Rules and TurboIntegrator

Definition

ISUNDEFINEDCELLVALUE compares the argument value with default numeric cube value and returns 1 if the cell value is equal to cube’s default value. 

Syntax

ISUNDEFINEDCELLVALUE(value).​

Value = A numeric value.

Video Demo

Use ISUNDEFINEDCELLVALUE function to compare numeric value with the cube’s default value and apply it in the cube rule to populate results in the Product Scorecard cube.