CrystalUser2006
Technical User
Hi,
Does anyone know how to get around error message using the XIRR function when the guess is wrong? I have set up an array for the dates and values to calculate a return, but I keep running into the problem of "numerical method did not converge, please try another guess".
I am using an OLEDB connection against a SQL Server 2000 database. The report is written in Crystal XI.
Any help would be greatly appreciated!
Thank you.
Does anyone know how to get around error message using the XIRR function when the guess is wrong? I have set up an array for the dates and values to calculate a return, but I keep running into the problem of "numerical method did not converge, please try another guess".
I am using an OLEDB connection against a SQL Server 2000 database. The report is written in Crystal XI.
Any help would be greatly appreciated!
Thank you.