Group formula

[Sambo8]

Hi all,

I'm using 8.5 and trying to show the following

Grouped on id

id @type
9999
Learn Y
Revise Y
8888 Learn Y
1111 Revise Y
Home Y

I've created a group formula that reads

if (@type = Learn and @type = Revise) then 'Learn & Revise') else @type

However no matter which combination appears in the details section my formula result always shows as 'Learn & Revise' any ideas where I've gone wrong?

Many thanks

Sam

 

[lbass]

What is the formula for {@type}?

-LB