Skip to Content
avatar image
Former Member

problem in XIRR Formula in Crystal Report

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.

Thanks

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Jul 14, 2017 at 01:53 PM

    Have you checked contents of the two arrays,

    Create two more formula to display contents

    whileprintingrecords;

    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.

    Ian

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

    Add comment
    10|10000 characters needed 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