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

      How to add a Calculated Field

      This article will go over how to add a Calculated Field to a table and will provide some common formulas.

      Casebook allows you to define new fields in the data set, named calculated fields. These fields are created by using expressions (formulas). An expression can be a combination of existing field(s), constant values and: predefined functions, and/or.

      Instructions for adding a calculated field:

      1. From the Report Builder, Select the + Icon in Fields SectionScreen Shot 2021-12-13 at 11.35.33 AM
      2. Select Calculated FieldScreen Shot 2021-12-13 at 11.37.33 AM
      3. Name the Calculated Field and select Done Screen Shot 2021-12-13 at 11.39.06 AM
      4. Enter in a formula or copy and paste the formula that you wish to use and select Create Field Screen Shot 2021-12-13 at 11.45.29 AM
      5. The new Calculated Field will populate at the bottom of the Fields list on the left-hand side of the Report BuilderScreen Shot 2021-12-13 at 11.46.34 AM

      To see these steps in action, check out the video below: