Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2006
    Posts
    12

    Exclamation Unanswered: IRR Function - Issue comparing results between systems

    Hi,

    I'm working on an income deferral problem and we are using IRR to end up calculating periodic income.

    As an example, I have the following inputs:

    Number of periods = 9
    Initial Loan = 21.46
    Instalment amount =15.30
    Future value=0
    Guess=0.1 (10%)


    Using a compiled function from Visual Studio in SQL Server 2008 we get a result of 70.71656373

    Using a Microsoft Access function we get NaN

    Using Microsoft Excel we get NaN

    Using a web calculator we get 70 (ish, the calculator rounds the numbers)

    I know that the numbers are odd, some of our data is dirty so we do expect that. I was expecting the SQL process to kick out an error (therefore converting the result into 0), but it doesn't.

    Can anyone explain this at all?

    Many Thanks!

  2. #2
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    We can't explain it unless you post your code and calculations.
    All our psychic DBAs have apparently dropped off the forum.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

Posting Permissions

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