sequential numbering in line item
I would like to know how can we create a sequential numbering in a line item. I saw some post where they use RANK but it does not fit the requirement needed.
In the module attached, I have a line item Transaction number where I want to show automatic numbering (1 - 100 for example) of the number of transactions. This will be used once it is imported to another model where there is a numbered list present. Is there a formula that will automatically show the numbers on the line item.
Thanks in advance