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
Thanks
pls anyone can help me in this problem it is little urgent
Add comment