Calculated Fields
      Back to home
      1. Knowledge Base
      2. Reporting
      3. Calculated Fields

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