Skip to Content
0
Former Member
Jan 10, 2008 at 10:40 PM

subscript

14 Views

Post Author: skootsu

CA Forum: Formula

Help!? I have inherited a big CR report that was done several years ago and now I have to 'fix it'. It was done orig. in 8.5, and I have 11.

I try to run it putting in the prompted parameters (they didn't note for the user the required format but I think I have it right), and am getting an error that pops up 'A subscript must be betweeb 1 and the size of the array.' Here is the formula, I don't know if this enough but any hints would be appreciated.

Formula-Operation ID

Shared StringVar Array aryBOM;

Shared NumberVar varArrayIndex;

StringVar Array aryBreakout;

If {#Line Number} <=Ubound(aryBOM) Then

(If aryBOM&#91;{#Line Number} &#93; <>"" Then

(aryBreakout :=Split(aryBOM&#91;{#Line Number}&#93;, " | ");

aryBreakout&#91;4&#93;))

Else

" "

Any ideas or pointers?

Thanks