Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have a requirement in which the user wants to assign records in a straight table to variable number of individuals assigned by number. For instance, the user wants to assign the records among 5 individuals. This would need to be variable on the front-end where I would have a slider object allowing the user to define the number of individuals. In this example they have selected 5. Can you reset the rowno(total) counter?
Item | Assigned Group |
---|---|
1 | 1 |
2 | 2 |
3 | 3 |
4 | 4 |
5 | 5 |
6 | 1 |
7 | 2 |
8 | 3 |
9 | 4 |
10 | 5 |
11 | 1 |
12 | 2 |
Mod(RowNo(Total)-1,$(vDivider))+1
=MOD(RowNo(Total)-1,$(Var3))+1
Thanks Gysbert!