Resource usage spreadsheet error
Forum Sponsor
Top Posters
James Williams
74 posts
Saqib Ullah
1 posts
Luyanda Ndlumbini
2 posts
Jeff Waldrop
6 posts
Robert Roy
1 posts
Tony Wright
4 posts
Arshman
0 posts
Stan Remiszewski
1 posts
GeoVe
0 posts
JAGAN REDDY MUSUKU
0 posts
Hi,
Did you ever get a resolution to this problem? i am experiencing the same issue with the total not calculating correctly.
Cheers
Tony
Hi,
Did you ever get a resolution to this problem? i am experiencing the same issue with the total not calculating correctly.
Cheers
Tony
Lucas,
Are we talking durations or labor units and non-labor units? There is no way calendar will affect resource unit or qty. Calendar and unit/time will affect durations but not resource.
Note: You cannot sum a combination of material qty, labor unit and non-labor unit on a summary band. It combine in a summary band it will display "---" but can sum per resource type.
Hi,
Its not a decimal problem as it show 3.00+3.00=9.57
The correct total is 0.615 times the value and apply for all the total for manhr and non man hr. There are no mistake for material.
I guess it is either calender or time period mistake. As I have change the calender from a 24hr calender to a 13hr calender. I tried changing the setting many times but couldnt resolve the issue
Lucas,
It’s nothing to do with your calendar. Your units may have decimal. Try to show the decimal so you know where the sum came from. Edit-> User Preferences-> Time Unit tab-> Unit of Time-> Decimals. Change the decimal to 2. Also check spreadsheet Option and culculate average maybe tick.