I have a bunch of sales data by company. I want to sum the total sales and then divide the individual company sales by the total. What's the best way to do this?
The total Sales which connects to the "S" input of the Append fields should only have one record, based on my understanding of your requirements.
Are you getting more than one record on this side?
Hi,I've attached a quick example of this.
Basically, you use two Summarize tools, one to get the Sum of Sales by Company, and one to get the total Sum of all Sales. Then you append the two together, and can use a formula to get your final calculation.
Hope this helps!
I tried this initially, but I received an error that says "There are more than 16 records in the source."
