Forum Discussion

vjnvinod's avatar
vjnvinod
Icon for Impactful Individual rankImpactful Individual
6 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"   Curr...
Need Help
Show and Tell
  • Greg_Deckler's avatar
    Greg_Deckler
    6 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"
)
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
6 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"
)
vjnvinod's avatar
vjnvinod
Icon for Impactful Individual rankImpactful Individual
6 years ago

Greg_Deckler 

 

thanks so much, this worked