codeFinder
Programmer
thread149-575997
Regarding above thread I have dynamic number of employees as columns.How to deal with this?
Currently I have hard coated all of my employees as follows in the formula.
if ({command.EMP_NO} in ['219'to '512'])then 0
else if ({command.EMP_NO} in ['515'to '642'])then 1
else if ({command.EMP_NO} in ['678'to '736'])then 2
else if ({command.EMP_NO} in ['737'to '781'])then 3
else if ({command.EMP_NO} in ['791'to '840'])then 4
else if ({command.EMP_NO} in ['853'to '872'])then 5
else 6
Regarding above thread I have dynamic number of employees as columns.How to deal with this?
Currently I have hard coated all of my employees as follows in the formula.
if ({command.EMP_NO} in ['219'to '512'])then 0
else if ({command.EMP_NO} in ['515'to '642'])then 1
else if ({command.EMP_NO} in ['678'to '736'])then 2
else if ({command.EMP_NO} in ['737'to '781'])then 3
else if ({command.EMP_NO} in ['791'to '840'])then 4
else if ({command.EMP_NO} in ['853'to '872'])then 5
else 6