Forum Discussion

V3GAS's avatar
V3GAS
Icon for Helper I rankHelper I
8 years ago

Use Allocated Accounting to Split Project Online Timesheet Actual Work

In our Project Online environment, we have project-level fields to capture Cost Centers (CC#'s 1-10)                   And for each Cost Center that is added to the project, a field tha...
Need Help
v-jiascu-msft's avatar
v-jiascu-msft
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

Hi V3GAS,

 

What does the original data look like? Can you share it? To be honest, your requirement here seems easy. It could be [work hours] * [percentage].

 

Best Regards,

Dale

V3GAS's avatar
V3GAS
Icon for Helper I rankHelper I
8 years ago

Dale,

 

I would think the calculation would be easy enough, but how would I take one resource's timesheet line with actual work hours to split it into multiple lines that have the percentages allocated to each cost center accordingly?

 

Here is a link to my .pbix file: PBI End Month Report