Hi all, hope somebody can help with this as i just cant figure out why this isn't working!

I'm using the resource usage view in project to allocate effort to individuals assigned to tasks. I have the view set to show week commencing dates and enter data from 0.5 to 5 days per week for each task.

I've created a custom Visual Report template based on the assignment usage data type. I create the usage data at the week level and select 'work' as the parameter to be exported.

when viewing the pivot table in Excel i can display by week number however the figures don't match what was entered in the Resource Usage view in Project. For Example i have a task with the following effort allocation:

Project:
Week Commencing 14/04 - 3 days
Week Commencing 21/04 - 2.5 days
Week Commencing 28/04 - 2 days

Visual Report:
Week Commencing 14/04 (Week 16) - 2 days
Week Commencing 21/04 (Week 17) - 0 days
Week Commencing 28/04 (Week 18) - 0 days

I don't understand what's going on, any help would be greatly appreciated!