Before we dive into calculations and how to create them, it is equally important to understand when to create calculations. Some examples of when calculations are useful are as follows:
- Changing datatypes: For example, you have data that is being represented as a string value.
- Performing mathematical calculations: For example, you want to divide two fields to obtain ratios or percentages or subtract fields.
- To create logical groupings/labels: For example, if you want to group people in those who can drive or not, you can create a calculation saying: if you are older than 18 and have a valid driving license, you can drive.
- To create new fields from existing data: For example, you want to create a country field by ...