Expression failing when there are multiple possible values
Hi guys. So I have a chart expression that contains an if statement looking for a certain field value. In that field, however, there are several possible values, depending on the current selections. I basically want the if statement to be true if one of the possible values is a string that I define. The expression always seems to return false though if there are multiple possible values.
So if my expression is like this:
=if(FieldA='Value", 'True','False')
And if the current possible values for FieldA given the selections are {'Value','Value2','Value3'}, I want the above expression to return true.
