Hello...bit of a challenge.
I am building a database and need to perform what essentially is a simple percentage calculation, with a twist.
Background:
Two tables: One with the 'percentages' of which there is the offered percentage the company wants to buy of the total, the estimated acceptance, and the final percentage that is bought.
The second table has the exposures.
Usually our company would just multiply its percentage share by the total value of the stock. What I want to do is say that if there is a final percentage, to use that in the calculation accross the two tables. If there is no final percentage, to use the estimated acceptance. If no estimate then use the offered percentage.
Any clues. Did I mention this was not all on one talbe but accross two. If that makes any difference.
Thanks,
CW
I am building a database and need to perform what essentially is a simple percentage calculation, with a twist.
Background:
Two tables: One with the 'percentages' of which there is the offered percentage the company wants to buy of the total, the estimated acceptance, and the final percentage that is bought.
The second table has the exposures.
Usually our company would just multiply its percentage share by the total value of the stock. What I want to do is say that if there is a final percentage, to use that in the calculation accross the two tables. If there is no final percentage, to use the estimated acceptance. If no estimate then use the offered percentage.
Any clues. Did I mention this was not all on one talbe but accross two. If that makes any difference.
Thanks,
CW