Multiplying rate with hours

[fjjpeeters1976]

Hi, 

I need help with the following. I am probably thinking to complicated.

I have a big database with total costs and hours worked by country. Based on this I calculate the costs per project hour (filtered on year), so outcome for one year is as following

In the same table I have a split for which business unit each country has worked for. So for example Finland worked 70 hours for BU A, 30 for BU B and 80 for BU C

Now I want to multiply the rates per country by the hours to get the following table. However I do not know exactly how to do this. Rates are based on countries and not on business units.

Any suggestions?

BR,

Frank

[fjjpeeters1976]

thanks for the help. sorry for my late reply

[some_bih · Accepted solution]

Hi @fjjpeeters1976 I created little file with some example data. Please check if it is good example for your case and desribe desired output. 

[some_bih]

Hi @fjjpeeters1976 possible solution depend how you organized your table inputs.

How your inputs tables look like? We see two pictures.

[fjjpeeters1976]

Basically I have 4 tables, one is a table with cost data from an ERP system, one other table is an hour report from a project management tool. I have another time table for all the days, months, years and I have one table which basically is just linking the cost and hour table based on countries (germany, finland, sweden). So with a filter on the year I have calculated the total cost by country dividing by the total projects hours by country. This gives me an hourly rate per country per year. So this hourly rate I would now want to multiply with the hours spend for each business unit.