SAP Knowledge Base Article - Public

2294933 - Argument #2 of 'XIRR' is out of range. error in Crystal Reports

Symptom

  • When you run a report with XIRR calculation you get the following error: "Argument #2 of 'XIRR' is out of range."

    XIRRArgumentOutOfRange.jpg

Environment

  • SAP Cystal Reports 2013

Reproducing the Issue

  1. Create a report with at least 2 fields (values and dates)
  2. Create a formula to collect the record values into 2 arrays (values and dates)
  3. Run XIRR with the 2 arrays
  4. Observe the error

Cause

  • The first date in the array represents the start of the schedule for XIRR
  • If the first date in the array is not the earliest, the function will fail
    (The rest of the dates doesn't have to be in order)

Resolution

  • Sort the report by date filed in ascending order

See Also

  • For more information on how to create XIRR calculation see KBA 2294925

Keywords

XIRR, calculation, formula, out, of, range, CR, CRD, internal, return, on, investment , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Problem

Product

SAP Crystal Reports 2013