COMPARE SAME DATA IN 2 GROUPS

[lulu801]

Group 1 = Account Number
Group 2 = Year (2011 and 2012)
Details include a 'class code' assigned to each account for each year. (ie acct number 123 has Class code A for 2011 and Class Code B for 2010; acct number 124 has Class Code A for both 2011 and 2010)

I am trying to format the font to a different color of the class codes are different between years (like in acct number 123 sample referenced above)

 

[lbass]

Go to font->color->x+2 and enter:

if distinctcount({table.classcode},{table.account#})>1 then
crred else
defaultattribute

-LB