| TotPriority3 | P3#Count |
| 6 | 1 |
| 6 | 1 |
| 6 | 1 |
| 6 | 1 |
| 6 | 1 |
| 6 | 1 |
if [Row-1:P3#Count] = 0 then 1
elseif ([Row-1:P3#Count] + 1) <= [Row-1:TotPriority3]
then [Row-1:P3#Count] + 1
elseif ([Row-1:P3#Count] + 1) > [Row-1:TotPriority3]
then [Row-1:P3#Count]
else 0
endif
I should be getting:
| P3#Count |
| 1 |
| 2 |
| 3 |
| 4 |
| 5 |
Seems [Row-1:P3#Count] always evals to zero? P3#Count type is Int32
Figured it out. I had group by wrong.
