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]) |