danesrood
07-21-2010, 01:00 PM
Dear All
I have a need to allocate a value which will change from month to month against the percentage loadings for each site. The allocated value can only be a whole number and the total amount of the allocated values must total the original value. In a perfect world I would prefer to use the 2 decimal places shown below but if it helps I could round up or down. All I am trying to achieve is a reasonably fair and accurate method of allocating the costs.
Value to be allocated say 34
Exeter 21.60%
London 16.99%
Glasgow 19.54%
Edinburgh 5.39%
Birmingham 21.10%
Bath 15.38%
Totals 100.00%
The values will change every month and the percentages annually.
Your help will be appreciated
Many thanks
I have a need to allocate a value which will change from month to month against the percentage loadings for each site. The allocated value can only be a whole number and the total amount of the allocated values must total the original value. In a perfect world I would prefer to use the 2 decimal places shown below but if it helps I could round up or down. All I am trying to achieve is a reasonably fair and accurate method of allocating the costs.
Value to be allocated say 34
Exeter 21.60%
London 16.99%
Glasgow 19.54%
Edinburgh 5.39%
Birmingham 21.10%
Bath 15.38%
Totals 100.00%
The values will change every month and the percentages annually.
Your help will be appreciated
Many thanks