Skip to main content

Hi friends

 

I need to show the values which should be filtered by two columns

 

And  more over that should be in calculated Column

I am using this below expression but I didn't get my result.

 

IF CONTAINS ([RESOLUTION],"HIGH") AND CONTAINS ([TYPE],"COMPLAINT") THEN  [NAME]  END

 

This expression give output as values of NAME where [Resolution] = "High" it didn't consider [TYPE] can you please help me  on this how can I write condition by using two columns and show the Single value

 

Please help ASAP its too imp..

6 answers
0/9000