Need Formula Help
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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!
- Labels:
- Help
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator