Allocation amounts = original amount

[Duncanmcl]

Access, how can I control and validate the sum of the allocated amounts equals the original totals exactly. When percentages are applied against an original amount, how can I verify programatically that all the parts equals the the original total, and/or adjust the total to equal that amount by adding 1 cent +/-.

thanks in advance

 

[JoeAtWork]

This would probably be easier to figure out if you could provide some sample data, i.e. what it looks like before and then how you would like it to appear.

I suspect it involves summing the allocated amounts and grouping by the foreign key that points to the "original budgeted amount" record.

 

[Duncanmcl]

ok....in my situation access is computing a bonus amount. Its necessary to allocate that amount between several markets representing different legal entities. For accounting GL purposes its then necessary to allocate each of those amounts between the 1 to 4 GL accounts each market may have. The sum of all the GL accounts must equal the original bonus amount. I have defined each calculation step as dollar formats and to let access control rounding and percisions. The various rations for GL are decimal 4. The original ratio between markets is double percision.

original bonus $4000

mkt1: 0.16703786192
mkt2: 0.70527097253
mkt3: 99.1276911656
note they add to 100
mkt1 amt:$6.68
mkt2 amt: $28.21
mkt3 amt: $3,965.11
note they add to $4000
mkt amt gl splits to 2 acconnts
GL1 ratio: 0.7777
GL1 amt: $5.20
GL2 ratio: 0.2223
GL2 amt: $1.49

The sum of ratios is 1.
The sum of GL1 and GL2 amt is $6.69, not the original $6.68

I have not included the other rations or amounts since the error is illustrated in the example.

Thanks in advance Jim