Skip to Content

problem in XIRR Formula in Crystal Report

Jul 14, 2017 at 10:27 AM


avatar image
Former Member

I have Created 2 Arrays one Number Array and one Date Array And Also i am displaying the array in detail section of report. both the arrays are showing proper and simultaneous values. But when i am using this array in XIRR Formula in my report it gives error as 'The Size of arrays must be the same Details XIRR' Can pls any one help me out in this matter.


10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Ian Waterman Jul 14, 2017 at 01:53 PM

Have you checked contents of the two arrays,

Create two more formula to display contents


global numbervar array test:= [1,2,3,4,5];

totext(Test[1]) &' '&totext(Test[2]) &' '&totext(Test[3]) &' '&totext(Test[4]) &' '&totext(Test[5])

Replace test with your arrays and make sure you are getting the output you expect.


NB-Join(Array, ",") only works with stringvar arrays

Show 1 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Thanks for your reply

I have Checked the Values of Both Array Number Array and Date Array all the Values are Proper. Now i have created new Formula as below

Shared Numbervar Array ClEq;

Shared Datevar Array TrdDt;

XIRR (ClEq,TrdDt)

When i check this formula it shows no error but when i preview the report it gives error as below

'Numerical Method did not converge, try another value for guess'

i have also tried with value of guess as 0,-1,1 but still it give same error. Can any one help me out in this Matter