Forum Discussion
Multiplying rate with hours
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
Hi fjjpeeters1976 I created little file with some example data. Please check if it is good example for your case and desribe desired output.
4 Replies
thanks for the help. sorry for my late reply
Hi fjjpeeters1976 I created little file with some example data. Please check if it is good example for your case and desribe desired output.
Hi fjjpeeters1976 possible solution depend how you organized your table inputs.
How your inputs tables look like? We see two pictures.
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.
