Level of detail calculation

juesong

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!!!

atcodedog05

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 😀👍

usage.yxmd