The Calculate operation performs a calculation, such as addition or subtraction,  with another column or with a specified value.

Video transcript

1. The Calculate operation performs a calculation, such as addition or subtraction, with another column or with a specified value.
2. Select the column to begin.
3. Available calculations
4. Now select the second column for the Addition calculation.
5. And apply the change.
6. The id column is updated, and the Steps panel 7. shows the completed operation.
7. You can also access the operations from the column's menu.
8. This time, select Is between two numbers. Specify the range, and create a new column for the results.
9. The new column displays in the table and the new calculate operation displays in the Steps panel.
10. This time, select Is equal to to compare two columns, and create a new column for the results.
11. The new column displays in the table and the new calculate operation displays in the Steps panel.