Hi All,

I'm trying to add in the terminal value number to array and am having difficulty. I'm using this array for an XIRR calc. XIRR calc's in crystal require a value and a date array set up. In this calculation, I need net contributions/distributions (which have 34 records) and then I need to add to the value/date section the terminal value which is only one number.

The formula I'm using (below) works, but it duplicates the first number in the array.

WhilePrintingRecords;
datetimevar array d;
numbervar array n;

numbervar x:= x + 1;
redim preserve d[x];
redim preserve n[x];
d[x]:= DateValue({Main.GL Date});
n[x]:= ToNumber({Main.Net Investor Contributions / Distributions});

//append arrays with terminal value
if onlastrecord then
(
x:= x + 1;
redim preserve d[x];
redim preserve n[x];
d[x]:= DateValue({PCAP.GL Date});
n[x]:= ToNumber({PCAP.Ending Capital});
);

The only logic that I think would remove the duplicate is by saying that IF NetContrib/Dist = NEXT Contrib Distib and GL Date = Next GL Date, then suppress. To be honest though, my array skills are very limited.

Does anyone have any thoughts on how to do this? I'd greatly appreciate it!

Regards,
Brandon