Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Oct 2004
    Location
    Minnesota, USA
    Posts
    151
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Weighted Average Maturity (Access 2003)

    I need to calculate the weighted average maturity across a portfolio of over 600,000 accounts. I know how to calculate the maturity it both days and fractional years. A simple average is easy using the built-in function. However, I need the weighted average and it's been too many years since I did that in school.

    Any suggestions?

    Thank you for all your help.

    Nancy

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Weighted Average Maturity (Access 2003)

    The expression for weighted average maturity is
    <code>
    Sum([Amount]*[Maturity])/Sum([Amount])
    </code>
    where Amount is the value the account. In a query you'd use it in a calculated column:
    <code>
    WAM: Sum([Amount]*[Maturity])/Sum([Amount])
    </code>
    and on a form or report in the Control Source of a text box:
    <code>
    =Sum([Amount]*[Maturity])/Sum([Amount])</code>

  3. #3
    2 Star Lounger
    Join Date
    Oct 2004
    Location
    Minnesota, USA
    Posts
    151
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Weighted Average Maturity (Access 2003)

    Thanks, Hans. I had the divisor as the Maturity. I knew it had to be something dumb like that.

    I appreciate your quick response.

    Nancy

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •