Skip to Content

XIRR Formula Parameter Problem

Jul 18, 2017 at 01:14 PM


avatar image

I have created 2 Arrays 1 Number Array and 1 Date Array and Checked all the Values it is Proper. Now when i pass the Array to XIRR Formula in Crystal Report 2016 and when i check formula for error it say No Error but when i preview report it gives me error 'Numerical Method did not converge; try another value for guess' The formula is as below

Shared Numbervar Array ClEq;

Shared Datevar Array TrdDt;

XIRR (ClEq,TrdDt);

I have tried with guess parameter as 0 but i am getting same error Can any one let me know what value i should give the value for guess parameter to solve my problem and run my report successfully


10 |10000 characters needed characters left characters exceeded

pls anyone can help me in this problem it is little urgent

* Please Login or Register to Answer, Follow or Comment.

0 Answers