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.