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

    Exclamation Unanswered: IRR Function - Issue comparing results between systems


    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
    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 "sqlblindman"

Posting Permissions

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