Information Calculated Fields

Information calculated fields are meant to be used to test the value of a selected field. They are particularly useful with large spreadsheets because you can check what type of information you are working with before performing a second calculation

The functions included in the information category are:

Function Name Syntax and Sample
empty: empty can be used to insert a column with empty cells. There are no arguments to configure. Syntax: empty()
Sample: empty()
isempty: isempty evaluates the specified expression, and checks if any row in your data source has empty values. Syntax: isempty({value})
Sample: isempty([ResignedDate])