I'm trying to use the counter to always increment by one across a variable number of layouts and across multiple records. 0-99, then loop back around.
I'm basically trying to get it so it runs like the following:
Record 1Layout 1: 0
Layout 2: Skipped
Layout 3: 1
Layout 4: 2
Layout 5: 3
Record 2Layout 1: 4
Layout 2: 5
Layout 3: Skipped
Layout 4: Skipped
Layout 5: 6
Record 3Layout 1: 7
Layout 2: 8
Layout 3: 9
Layout 4: Skipped
Layout 5: 10
Record 4Layout 1: 11
Layout 2: 12
Layout 3: 13
Layout 4: 14
Layout 5: 15
...and so on
The closest I've gotten so far is with this expression:
COUNTER(PAGE_NR()-1, 99, 1, 2, True)
But it is jumping a number between each new record.
Also, I know that the above code wont loop back around to 0 after reaching 99, I was just trying to solve one problem at a time
Thanks