You can use simple number functions to perform useful percent calculations. Simple number functions include addition, subtraction, multiplication, and division.

Function	Description	Examples
*	Returns the result of multiplying both numbers.	3 * 2 = 6 price * taxrate
+	Returns the result of adding both numbers.	1 + 2 = 3 price + shipping
-	Returns the result of subtracting the second number from the first.	3 - 2 = 1 revenue - tax
/	Returns the result of dividing the first number by the second.	6 / 3 = 2 markup / retail price

Calculate percentages

Calculating percentages is useful when you want to see, for example, the percentage of revenue that each retail department generates (gifts, bakery, canned goods, etc.).

Create a formula called Percent Revenue in the Formula Assistant:

( sum ( revenue ) / group_sum ( revenue ) ) * 100

Replace revenue with your company’s name for their revenue column, such as revenue_dollar_amount.

Now you can see the percentage of your total revenue that each department contributes, using the percent revenue formula that you just created. See the example below.

formulas