Calculation with different dimensions

Options
kenzael
kenzael Member, ALL USERS, Certified Model Builder Posts: 5 Occasional Contributor
in Planning & Modeling

Hi,

 

I have 2 modules : one with the headcount and the other one with average salaries.

I want to create a third module with total salaries (which is headcount*average salary).

 

But, in the headcount module I have the headcount with line items internal vs external, and for salaries I have salary as line item. How can I calculate the total salaries with distinction internal/external if I don't have them as line items in average salaries module?

I tried to do a formula like IF is internal? or LOOKUP but I don't manage to make it work.

kenzael_1-1603459785728.pngkenzael_2-1603459803170.png

 

kenzael_0-1603459766005.png

Thank you for your help!

Tagged:

Comments

  • kenzael
    kenzael Member, ALL USERS, Certified Model Builder Posts: 5 Occasional Contributor

    Hi anirudh,

     

    Thank you, but I still want the split between internal and external in the module total salaries. With the formula you suggest, I sum up both internal and external salaries

     

    Thank you

Categories