Help with grouping

[wanzek1]

Why can't I use this formula as a group?

if Sum ({@First Year}, {@SortEmployee})>0 and Sum ({@First Year}, {@SortEmployee})<=60000 then 'Under $60,000'
else if Sum ({@First Year}, {@SortEmployee})>60001 and Sum ({@First Year}, {@SortEmployee})<=114999
then '$60,001 to $114,999'
else if Sum ({@First Year}, {@SortEmployee})>=115000 then 'Over $115,000'
else 'No 2012 Wages'

 

[pmax9999]

The formula can only be evaluated at Print Time, because it uses existing groups. It is then too late to use as the basis of another group.

Pete

 

[wanzek1]

Do you have any suggestions as to how I can group these then?