Forum Discussion

vjnvinod's avatar
vjnvinod
Impactful Individual
5 years ago
Solved

help with Search function

Hi Team,

 

below is my coloumn

 

 

 

and calculated coloumn

status =
IF(SEARCH("NoNoNo",'Ch2 GCSPs'[Region&SLnow&oldSL&exception&TBC&Duplicate],1,0)>0,"In Markets, Other SMU"
 
Currrently i have given "NoNoNo" as a search criteria
now i need output based on 2 combinations
CBS and NoNoNO
basically if a text row contains CBS and NoNo then give me the output as "In Markets, other SMU"
 
Need Help
Show and Tell
  • Greg_Deckler's avatar
    Greg_Deckler
    5 years ago

    vjnvinod 

    status =
IF(
  SEARCH("NoNoNo",'Ch2 GCSPs'[Region&SLnow&oldSL&exception&TBC&Duplicate],1,0)>0 &&
    SEARCH("CBS",'Ch2 GCSPs'[Region&SLnow&oldSL&exception&TBC&Duplicate],1,0)>0,
  "In Markets, Other SMU"
)

3 Replies