- Knowledge Base
- cb Reporting
- 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:
- From the Report Builder, Select the + Icon in Fields Section
- Select Calculated Field
- Name the Calculated Field and select Done
- Enter in a formula or copy and paste the formula that you wish to use and select Create Field
- The new Calculated Field will populate at the bottom of the Fields list on the left-hand side of the Report Builder
To see these steps in action, check out the video below:
