Suppress if A or Supress if B

[SDS100UK]

Hi,

Could someone please give the code that says:
If fieldA = "cat" or fieldB = "dog" or fieldC = "Pig" then. . . .

I know how to do this in VB but do not understand Crystal Syntax.

Thanks very much

Steven

 

[FoxG]

Hi Steven,

You put your answer in your question!
If your formula doesn't work as it stands try adding brackets to force it to calculate the or's correctly.

If (({fieldA} = "cat&quot or ({fieldB} = "dog&quot) or
({fieldC} = "Pig&quot)
then "It is a cat or a dog or a pig!!"
else "It is not!!"

Hth,
Geoff

 

[FoxG]

Hi Steven,

If it is a suppression formula you just need...


(({fieldA} = "cat&quot or ({fieldB} = "dog&quot) or
({fieldC} = "Pig&quot

Geoff

Ps. Only one close bracket should be after "Pig"
The second bracket was a mistake!!