Skip to Content
avatar image
Former Member

XIRR Formula Parameter Problem

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers