When we export (via reports) or copy time-distributed resource loading from P6 to excel, the loading data doesn't add-up correctly and have some difference from total Budgeted units (both at activity level and higher levels). Though the difference of units is quite small but when we are using this Resource Loading for Project's Cost Planning, the difference in overall Project Budget becomes evident.
One thing i know is that P6 round-off Resource Units Loading data up to maximum of 2 decimal places, which results in this small difference in decimals and the same rolls-up to overall project level in project cost.
Is there any solution through which the sum of Resource Loading data matches exactly with the Budgeted Units allocated to activities?
OR
Is there any way we can increase the limit of 'Decimals' more than 2 in 'User Preferences'?
Regards,
Umer