Arithmetic
Arithmetic combines two fields with an operator to create a new one.
Add (+)
Adds the values of two fields together.
Inputs
| Input | Required? | Description |
|---|---|---|
| Base field | Yes | The first numeric field. |
| Plus | Yes | The field to add. |
Use cases
- Total cost = price + shipping
- Fully loaded salary = base pay + bonus
- Session length = active time + idle time
Subtract (-)
Subtracts the value of one field from another.
Inputs
| Input | Required? | Description |
|---|---|---|
| Base field | Yes | The field to subtract from. |
| Minus | Yes | The field to subtract. |
Use cases
- Profit = revenue − cost
- Net price = list price − discount
- Remaining quota = limit − usage
Multiply (×)
Multiplies the values of two fields.
Inputs
| Input | Required? | Description |
|---|---|---|
| Base field | Yes | The first numeric field. |
| Multiplied by | Yes | The field to multiply by. |
Use cases
- Line total = price × quantity
- Tax amount = taxable total × tax rate
- Weighted score = rating × weight
Divide (÷)
Divides the value of one field by another.
Inputs
| Input | Required? | Description |
|---|---|---|
| Base field | Yes | The numerator. |
| Divided by | Yes | The denominator. |
Use cases
- Conversion rate = orders ÷ visits
- Average order value = revenue ÷ orders
- Attach rate = add-ons ÷ base products