RemoveNull()
Use RemoveNull() to remove null values from a collection.
Category: Technical Reference
RemoveError()
Use RemoveError() to remove errors from a collection.
ReplaceError()
Use ReplaceError() to replace errors in a collection with the last known value.
ReplaceNull()
Use ReplaceNull() to replace null values in a collection with the last known value.
CatchNull()
Use CatchNull() to get a default value if a null occurs in the supplied argument.
SingleValueIf()
Use SingleValueIf() to take a single value and return either the true or false value, where the types of the true or false values do not have to match.
TimeNe()
Use TimeEq() to get the number of seconds, during the interval from StartTime to EndTime, that the value of the expressions are equal.
TimeLt()
Use TimeLt() to get the number of seconds, during the interval from StartTime to EndTime, that the value of one of the expressions is less than the other.
TimeLe()
Use TimeGe() to get the number of seconds, during the interval from StartTime to EndTime, that the value of the expressions are greater than or equal to each other.
TimeGt()
Use TimeGt() to get the number of seconds, during the interval from StartTime to EndTime, that the value of one of the expressions is greater than the other.