True or False if value exists

[#1]

Hey,

Iam importing a excel sheet. I make a gauge chart (showing green or red light) if the value is there.

As an example i got a field named Object.

I want the light to be red if the object field consists of value "SSSMMM" and green if the valie "SSSMMM" is not there.

Tried the expression if(Object='SSSMMM', 'True', 'False'")

Any ideas here?

Thanks

[Gysbert_Wassenaar · Accepted solution]

Try if(Object='SSSMMM',1, 0)

[amit_saini]

Erik,

This should work:

If(Object='SSSMMM','Yes','No')

If not share your application.

Thanks,
AS