using AND and contain functions in data slice

Hi there

I have a slice of data base. One the variable is "tagname". 

I would like to show the variables whihc are having :

UFD and VOLTAGE

or 

UFD and Frequency

I have used this code but this does not work: 

OR (
AND(CONTAINS([tagName], “UFD” ),CONTAINS([tagName], “Voltage”)),
AND(CONTAINS([tagName], “UFD” ),CONTAINS([tagName], “frequency”)),
)

Please tell how manage this? 

 

Thaks

Solved Solved
0 2 188
1 ACCEPTED SOLUTION

Remove the comma after the second AND() and try again.  Having extra comma's leads to unexpected results.  Otherwise the expression looks correct.

View solution in original post

2 REPLIES 2
Top Labels in this Space