CatchNull()

Format

CatchNull(Arg1 ,DefaultValue)

Returns

Returns the value of Arg1, replacing any null values in the collection with the value of DefaultValue.

Inputs

Arg1: The argument being checked for errors and lack of samples or data.
Behaviour: Required
Dimension: Error, Collection, SingleValue, Matrix, MultiCollection
Valid data types: Null, Boolean, DateTime, Decimal, Integer, String, Duration, Error

DefaultValue: The value to be returned if a null occurs. Must be a constant.
Behaviour: Required
Dimension: SingleValue
Valid data types: Null, Boolean, DateTime, Decimal, Integer, String, Duration

How to format data types

Release History

• CatchNull() 4.6.5
  • Changed Arg1 parameter to support MultiCollection values.
• CatchNull() 4.0
  • Initial version