function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
aknightaknight 

Product line sales as a % of total sales

I need a formula that will show me the percentage breakdown of a product mix within the whole product line. I have a report that shows me the different products by quantity sold for the year and the grand total for all product lines, but I cannot figure out how to show this as a percentage, any ideas?
 
ie. Product A: Sales 50, Product B: Sales 130, Product C: Sales 17. Total Sales 197
 
Product A: 25.39%
Product B: 65.98%
Product C: 8.62%
 
 
Andrew
Scott JorgensenScott Jorgensen

I think you can use a report formula like this:

{!TOTAL_PRICE:SUM}  / {!AMOUNT:SUM}