Need Formula Help

Question

Could someone please help me with how to set up a formula? I want to calculate what percentage each unique location code is of the total when the company code and state code match. For example, on the first 3 lines the company code of 12 and state code of 1 match and equal $113. Location code 31 would be 23/113, location code 32 would be 25/113, etc. for each combo of company code and state code. Hopefully I explained that properly. Let me know if I can clarify anything and thanks in advance for your help!

nagakavyasri · Answer

Formula1.yxmd

ChrisTX · Answer

Use a Summarize tool.  Group by Company Code and State Code, Sum on Amount

Then a Join tool to add the field for [Sum on Amount] back to the original data stream (before the Summarize tool).  Join on Company code and State Code.

Then a Formula tool to calculate Percent of Total:  ([Amount] / [Sum of Amount]) * 100.  Use an output data type of Fixed Decimal.

Chris