Results 1 to 2 of 2
2008-06-26, 15:50 #1
- Join Date
- Mar 2006
- Pittsburgh, Pennsylvania, USA
- Thanked 1 Time in 1 Post
Calculating a distribution (2003 sp2)
An account or holder, may have many assets and an asset may be held by many holders. When I receive a file that contains a list of properties (Assets) with related fees for taxes or insurance, it is my job to charge the holders their percentage of the fee based on the units they hold of the particular asset. I have always done this in a query by multiplying the fee by the fractional share. This has always left a few rounding issues that I have dealt with manually. If a property is held in three accounts, .333, .333, and .334, how could I calculate the first two and just assign the balance to the third. Or if there were five holders assign the balance to the fifth, and so on?Thanks
2008-06-26, 17:03 #2
- Join Date
- Jun 2001
- Crystal Beach, FL, Florida, USA
- Thanked 36 Times in 35 Posts
Re: Calculating a distribution (2003 sp2)
First of all, you can use the Round() function to handle the rounding, something like round(share * Fee,2) will round to cents.
Making the sum of distributions equal to the total Fee (for example) is a little trickier. Assuming you have written some sort of transaction record, you could sum the transactions for each Fee and compare the totals, to see how much of an adjustment (if any) needs to be made to that "last" account. The problem is, which is the "last" account for an asset?