Actual cost of the ERP programme

Actual cost = FactCost Amount + hours x HourlyRate for every timesheet line (DimResource rate; crews are 0). What is the actual cost of the four ERP projects (Programme "Group ERP") together, in USD?

Expected: One amount in USD, 2 decimals · KPI card
Tables: FactTimesheet, FactCost, DimResource, DimProject · columns

FactTimesheet
FactCost
DimResource
DimProject

Amount
Hours
HourlyRate
Programme
Topics: Cost & Operating Expenses Budget & Variance

Discussion

No one has posted here yet. Ask something, compare your result, or share how you solved it.

Join the discussion

A free account takes a minute. Your draft is kept while you sign in. Need help? Message us

Create a free account Sign in