Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

How to create a sub index column

Hi!

I have a table sort of transactions table. The rows, 11 at a time belongs to one transaction. I've created a index column with Modulo function so each group starts with 0 zero and goes up to 10 and starts over. 

 

I want to add a new column so the first group of 11 transactions will all have 1, the next 11 will all have 2 and so forth. What function do I need to accomplish this or what's the best way to approach this?

 

/Magnus

  • Create an Index column and then you can do this:

     

    Column = ROUNDUP([Index]/11,0)

3 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion

    Create an Index column and then you can do this:

     

    Column = ROUNDUP([Index]/11,0)
    • Anonymous's avatar
      Anonymous
      Not applicable

      Ok where do I put your code? 

    • Anonymous's avatar
      Anonymous
      Not applicable

      Thanks! Got it working :-)