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.
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
Member for
19 years
Member for19 years
Submitted by Rodel Marasigan on Sat, 2010-05-22 07:17
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.
Member for
13 years 9 monthsHi, Did you ever get a
Hi,
Did you ever get a resolution to this problem? i am experiencing the same issue with the total not calculating correctly.
Cheers
Tony
Member for
13 years 9 monthsHi, Did you ever get a
Hi,
Did you ever get a resolution to this problem? i am experiencing the same issue with the total not calculating correctly.
Cheers
Tony
Member for
19 yearsRE: Resource usage spreadsheet error
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.
Member for
15 years 7 monthsRE: Resource usage spreadsheet error
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
Member for
19 yearsRE: Resource usage spreadsheet error
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.