Basic Calculations
Multiplication (*)
This returns the result of multiplying two numbers.
3 * 2 = 6
amount * net amount
Addition (+)
This returns the result of adding two numbers.
1 + 2 = 3
net amount + fee
Subtraction (-)
This returns the result of subtracting the second number from the first.
3 - 2 = 1
amount - fee
Division (/)
This returns the result of dividing the first number by the second.
6 / 3 = 2
amount / gift count within filtered period
Percent Calculations
You can also use simple number calculations to perform helpful percent calculations on your data. Calculating percentages is a great way to gain perspective on your data, such as seeing the percentage of amount that each specific payment method generates (like card, check, or other methods).
To get started, create a formula called Percent Amount in the Formula Assistant:
( sum ( amount ) / group_sum ( amount ) ) * 100
Be sure to replace amount with your specific column name, such as amount_dollar_value.
Once your formula is ready, you can easily see the percentage of your total amount that each payment method contributes to the total amount:
