circular reference

[Duncanmcl]

Business situation where a max amount/policy can be paid only, lets call it a maxbonusperpolicy. The totalbonus is made up of many policies and the rule is the ratio of members one policy to the total members all policies, a ratio (on each policy)applied to the totalbonus can not exceed a set amount. if the ratio * totalbonus exceed this max amount then the totalbonus is reduced by this amount. Unfortunatually a recalculation using the adjusted amounts may still show an excess amount, since the total amount has decreased and the ratio (this one policy) is unchanged. The start of a circular reference....again and again. I believe this can be handled in Excel with a function called itteration...although I have not found it.....is there a way to handle this in Access....so the amount reduced will meet the test on recalculation.

 

[lameid]

Some of that is ambigous. Can you define your totals and ratios etc. in terms of SQL and provide some logic using math formulas?

 

[ZmrAbdulla]

May be a creating function and calling it in as query will give some help.

________________________________________________________
Zameer Abdulla
Help to find Missing people