XIRR Formula Parameter Problem

[Former Member]

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

[Former Member]

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

[former_member11696 · Accepted solution]

XIRR appearrs to be a custom User Function that is not included with CR.

Contact the makers of the XIRR UFL for assistance.