How to get the data from previous to last repeating field?
I know, I know, I've read all the issues with repeating fields. But, what's done is done, and I've not much time to muck more in the DB.
Question: In a report, I can get the Last repetition and display it easily (well, it's easy now cause some nice folks here helped me) - and of course, now management would like to see how that data relates to the one before. Oh, bother.
I can't use get repetition number, because it may be different depending on the record -
Record | Rep1 | Rep2 | Rep3 | Last Rep | Previous Rep |
yoyo 2 3 2 2
gogo 1 1 1
momo 2 1 1
I want to show in "Previous Rep" that yoyo was 3, gogo was 1, and momo was 2. And, of course, it updates as each record is updated.
Something like Last Repetition -1, but Lord help me, I'm just not that bright.
Can you help me with a calc (I assume this is what you'd use) that will work for this?