Calculation with different dimensions
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.
Thank you for your help!