Symptom
- When you run a report with XIRR calculation you get the following error: "Argument #2 of 'XIRR' is out of range."
Environment
- SAP Cystal Reports 2013
Reproducing the Issue
- Create a report with at least 2 fields (values and dates)
- Create a formula to collect the record values into 2 arrays (values and dates)
- Run XIRR with the 2 arrays
- 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