Formulas

[bsolove]

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?

[Claje]

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!

[bsolove]

I tried this initially, but I received an error that says "There are more than 16 records in the source."

[ydmuley]

Hello @bsolove you are getting this error on which tool?

[Claje · Accepted solution]

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?

[bsolove]

That error was on the append field tool.

[bsolove]

That worked when I switched the connector.  Thanks!