Trying to not include previous formula results?

[pokerace]

C10 ODBC

I am grouping a report based on a formula field that works something like this:

if {table.classname} = "A" then "Group 1" else if
{table.classname} = "B" then "Group 2 else if
{table.classname} = "C" then 'Group 3 else
"Other Group"

Here is my problem. If Joe Smith has a classname of A as well as a classname of X, then Joe Smith would appear both in the "Group 1" list as well as the "Other Group" list.

I want people's names to show up in the "Other Group" category ONLY IF they don't fall under one of the first three if statements. Is there a way to do that?

 

[pokerace]

Let me also add that if Bill Smith has classnames of M, W, and X then I only want Bill's name and corresponding data to appear once under the "Other Group" field.

 

[lbass]

I think you could insert a group on this formula {@Group}:

if {table.classname} in ["A","B","C"] then
{table.classname} else "Other"

Then create a second formula {@ABC}:

if {table.classname} in ["A","B","C"] then 1

Insert a second group on the student name, and suppress the details section. Then in the section expert highlight Group #2 (student) header->suppress->x+2 and enter:

{@Group} = "Other" and
sum({@ABC},{table.student}) > 0

-LB