Preventing Arithmetic overflow error when using POWER function

• Chrissy321

  SSCoach

  Points: 15768

  More actions

  June 28, 2023 at 4:04 pm

  #4221743

  Hello,

  Any help appreciated. This code should perform a internal rate of return (IRR) calculation. It generates correct data based on what was provided to me using Excel's IRR function.

  It looks like as GETDATE() gets close to my hard coded date the error is generated. Any suggestion to prevent the error would be appreciated.

  SELECT
  POWER
  (
  CONVERT(FLOAT,CONVERT(DECIMAL(30,6),322.000000)/NULLIF(4.079000,0)),
  CONVERT(FLOAT,365)/COALESCE((NULLIF(DATEDIFF(d,GETDATE(),'2023-06-30'),0)),365)
  ) 
  -1

   

• Site Owners

  SSC Guru

  Points: 80325

  More actions

  June 29, 2023 at 4:10 pm

  #4222618

  Thanks for posting your issue and hopefully someone will answer soon.

  This is an automated bump to increase visibility of your question.