Display Yes/No 1

[nb4884]

Hi All,

I have a field Class, Data as A, B, C, D
And a project can have any one class or multiple.
Class is not a Boolean, its just a string value.

Now if my project has Class A
How do I display as Yes and if it does not have Class A then NO

This is how I tried, but it gave opposite results.

If ({Query1.Class}) = 'A' then 'Yes' Else 'No'

But my project had a Class A and still it displayed No.

It displays anything that I write in Else '

Please suggest what is going wrong here.
Thanks

 

[lbass]

If you place the Class field in the detail section, does each letter appear in a different row, e.g.,

A
B
C

Or does the field display all in one row, like:

A, B, C

?

-LB

 

[nb4884]

I have my data in group footer. If I display Class in group footer then it displays only one value B , however my project has 3 classes as A, B, C.

 

[lbass]

Change your formula to:

//{@A}:
if {Query1.Class} = 'A' then 1

Then create a second formula like this for the group footer:

if sum({@A},{table.project}) > 0 then
"Yes" else
"No"

-LB

 

[nb4884]

Thanks LB, the above formula worked.