FORMULA LANGUAGE

Examples: @IsNull
This function, when used as a field formula, finds the square root of each element in the text list in the OriginalList field. @IsNull is first used to test the OriginalList field to ensure that it contains a value and prevents the formula from calculating the square roots if it does not. If OriginalList contains 4: 25, the result is 2; 5. If OriginalList is a null field, the result is a null field, not an error.

@If(@IsNull(OriginalList); @Nothing;

@Transform(OriginalList; "x";

@If(x >= 0; @Sqrt(x); @Nothing)))

See Also