I want to have a serial number or a line number each line in my Repetitive Area which were my Items are indicated. i used LineNum() to display the numbers as my serial number. Now what i want is to hide/Suppress the line number if the line is a text type or alternative type.
For Example:
1. Item1
2. Item2
Heres some Text Line
3. Item3
Heres Alternative Product
4. Item4
By using the LineNum() and hiding if the Type is Text line or Alternative it will show as the below:
1. Item1
2. Item2
Heres some Text Line
4. Item3
Heres Alternative Product
6. Item4
i've tried to use also the ToNumber() but the problem with this is if the user inserts a product in between the first data inputs, it will not follow the numbering sequence.
Please help me to solve my problem.