Use simple number functions to calculate a percentage, such as the share of total revenue each department generates.You can use simple number calculations — addition, subtraction, multiplication, and division — to perform useful percent calculations on your data. Calculating percentages is useful when you want to see, for example, the percentage of revenue that each retail department generates (gifts, bakery, canned goods, and so on). Create a formula called
Percent Revenue in the Formula Assistant:
revenue with your company’s name for its revenue column, such as revenue_dollar_amount.
Now you can see the percentage of total revenue that each department contributes, using the percent revenue formula you just created.