using AND and contain functions in data slice

[haplc]

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

[WillowMobileSys · 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.

[haplc]

Many thanks. That has worked exactly as I would like to have. 

You are right: at times, we are just a click or comma away 🙂

Best regaards