ISDEFINED function

  • 21 December 2021
  • 0 replies
  • 191 views

 

Description

Returns TRUE if the given parameter refers to non-empty value, BLANK otherwise.

Note: This function is equivalent to the function ISNOTBLANK but returns BLANK values instead of FALSE.

Warning:  Boolean operator and Dimensions alignment can be misleading on blank values. Please double check the AND , OR and NOT operator behavior on blank values.

 

Syntax

ISDEFINED(metric/property)

 

Return type

Boolean

 

Example

Case

Results

Return Type

ISDEFINED(MyMetric)

Returns TRUE only for cells in MyMetric in which there are data

Boolean

 

 

See also: ISNOTBLANK


0 replies

Be the first to reply!

Reply