Forum Discussion
Helper IIIMultiplying rate with hours
Hi fjjpeeters1976 I created little file with some example data. Please check if it is good example for your case and desribe desired output.
Community ChampionHi fjjpeeters1976 possible solution depend how you organized your table inputs.
How your inputs tables look like? We see two pictures.
Helper IIIBasically 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.