Hi, I am dealing with the below scenario.
Table A: Territory-Level Info
Territory | Month | Territory Revenue | Territory Usage |
Territory A | Oct | 1000 | 100 |
Table B: Account-Level info (multiple accounts under one territory)
Account | Territory | Month | Account Usage |
Account A | Territory A | Oct | 10 |
Account B | Territory A | Oct | 90 |
Desired Output: Calculate account-level revenue based on usage
Account | Territory | Month | Account Usage | Account Revenue |
Account A | Territory A | Oct | 10 | 100 |
Account B | Territory A | Oct | 90 | 900 |
Any guidance would be greatly appreciated!!!
Résolu ! Accéder à la solution.
Hi @juesong
Here is a workflow for the task. I am assuming the calculation here as ratio.
Output:
Workflow:
Calculation assumption. Calculating portions of
100 -> 1000
90 -> ?
? = (90/100)*1000
= 900
Hence formula
([Account Usage]/[Territory Usage])*[Territory Revenue]
Hope this helps 🙂 Feel to ask if you have any questions
If this post helps you please mark it as solution. And give a like if you dont mind 😀👍
Hi @juesong
I have updated my solution with a logical calculation assumption for calculating part of whole. 🙂
Appreciate your help!
Thanks a lot for your help!
Happy to help 🙂 @juesong
Cheers and Happy Analyzing 😀
Feel free to reach out if you face any issues 🙂