Index with max number

[simo595a]

Hi guys, I need som help wit indexing tables with a cap on the index number.

The goal is an index from lets say 1:15. When the index reaches 15, then it should do another iteration of 1:15 indexing until the end. The number is dependent on another index in another table with no relationship.

Any recommendations on how to proceed?

Any help would be much appreciated.

[colacan · Accepted solution]

@simo595a  Hi,

You may use Index column with Mathfunction of MOD( ) as below.

IF( MOD([Index],15)=0, 15 , MOD([Index],15) )

To retrive [Index] from other table with no relationship, you amy use either Lookup( ) function or Treatas( ).

Hope this helps.

[simo595a]

Hi @colacan,

Thank you very much for your suggestion.

Everything works accordingly now - thanks a lot!!!!