Last Repeating Field that has a value...
I need to calculate the last repeating field that has a value in it.
Not the value itself BUT the field number.
I have a repeating field of 10 repetitions...
1,1,F, , , , , ,1, = 9 as 9 is the last repeat filled in
, , , ,A, , , , , = 5 as 5 is the last repeat filled in
How can I do that please?