calculatestatement is used to perform arithmetic operations using literal and column values.
source operation source
+ - * / %for addition, subtraction, multiplication, division and modulo respectively.
calculate column ResultCol as column Amount * value 1.2
calculate column Net as column total - column cogs
calculate column constant_7 as value 3.5 + value 3.5
Nwhere N is the literal number required
colNamewhere ColName is the name of the column containing the values required
calculate column Rate as column Rate + value 1.5
calculate column Charge as column Rate * column Quantity