Forum Discussion
Solved
Project for web - task cost
Hi, Is there any indication that the ability to set & report individual task costs is coming to project for the web? I know this is available in Dynamics - Project operations, but we would not i...
Jason_Reece As previously mentioned there is no way to calculate and view costs in Project for the Web. Another option would be to calculate these costs using Power BI. We actually do this with Project Online data as you can't rely on the cost calculations coming out of MSP Online and we have additional cost calculations that MSP Online can't provide.
- Create an AssignmentCost table with timephased assignment data
- Create a Resource Rate table with effective dates and rates
- Do a conditional merge, merging item 2 with item 1 then calculate costs (hours * rate)
Jason_Reece As previously mentioned there is no way to calculate and view costs in Project for the Web. Another option would be to calculate these costs using Power BI. We actually do this with Project Online data as you can't rely on the cost calculations coming out of MSP Online and we have additional cost calculations that MSP Online can't provide.
- Create an AssignmentCost table with timephased assignment data
- Create a Resource Rate table with effective dates and rates
- Do a conditional merge, merging item 2 with item 1 then calculate costs (hours * rate)
- Thank you.
I have a small project that I can try this on, so I will give it a go.
