Forum Discussion
Solved
Show Maximum value?
I have managed to create an index column that appears to be working how i need it to (i have added that total field in screenshot view) What I would like to do is have the final view to show t...
You can add index column starting from 1, and then replace 1 with null.
his is the data, i hope it copies ok.
Bascially the first instance there is no recurrence as its the first iteration the second shows 1 but should be 2 so the overall total of this one would be 11 and not 10 - its ok if that repeats on each row
| Reference | Damaged Code | Recurrence |
| 1-2017-0045 | 797.050 | |
| 1-2017-0067 | 797.050 | 1 |
| 1-2018-0056 | 797.050 | 2 |
| 1-2018-0104 | 797.050 | 3 |
| 1-2019-0043 | 797.050 | 4 |
| 1-2019-0044 | 797.050 | 5 |
| 1-2019-0107 | 797.050 | 6 |
| 1-2020-0013 | 797.050 | 7 |
| 1-2020-0042 | 797.050 | 8 |
| 1-2020-0055 | 797.050 | 9 |
| 1-2021-0033 | 797.050 | 10 |
lbendlin
Super User
Super UserYou can add index column starting from 1, and then replace 1 with null.