Calculating sum total and percentage
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
SCK
8 - Asteroid
‎04-12-2021
04:14 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hello all - I need another help. I need to calculate total of the dataset and then percentage of total only for a dataset with over 100 clients together. Please help.
Input:
Client | Client Number | Data | Data1 | Data2 |
A | 1 | Cash | 3 | 50 |
A | 1 | Accounts Payable | 4 | 110 |
A | 1 | Accounts Receivable | 5 | 250 |
A | 1 | Inventory & COGS | 6 | 200 |
B | 2 | Cash | 7 | 150 |
B | 2 | Accounts Payable | 8 | 85 |
B | 2 | Accounts Receivable | 9 | 90 |
B | 2 | Inventory & COGS | 10 | 110 |
Output:
Client | Client Number | Data | Data1 | Data2 | Ratio |
A | 1 | Cash | 3 | 50 | |
A | 1 | Accounts Payable | 4 | 110 | |
A | 1 | Accounts Receivable | 5 | 250 | |
A | 1 | Inventory & COGS | 6 | 200 | |
A | 1 | Total | 18 | 610 | 0.029508197 |
B | 2 | Cash | 7 | 150 | |
B | 2 | Accounts Payable | 8 | 85 | |
B | 2 | Accounts Receivable | 9 | 90 | |
B | 2 | Inventory & COGS | 10 | 110 | |
B | 2 | Total | 70 | 1655 | 0.042296073 |
1 REPLY 1
Assaf_m
11 - Bolide
‎04-12-2021
04:33 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
