Arithmetic Operators
Arithmetic operators perform basic math operations on 2 expressions of the same field type resulting in a numeric value.
Example: You can calculate the gross profit margin percentage using the values of a [total_revenue] and [total_cost] field:
(([total_revenue] - [total_cost]) / [total_cost]) * 100
Operator | Meaning | Example |
|---|---|---|
+
| Addition | [amount] + 10
Add 10 to the value of the [amount] field. |
-
| Subtraction | [amount] - 10
Subtract 10 from the value of the [amount] field. |
*
| Multiplication | [amount] * 100
Multiply the value of the [amount] field by 100. |
/
| Division | [bytes] / 1024
Divide the value of the [bytes] field by 1024 and return the quotient. |