Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I am trying to use the like operator in set analysis, I have a comment field and I want to count the different comments like
=count(DISTINCT {<InteractionName={'Uncontactable','Uncontactable closed'},Comment={'*Uncontacted*','*Wrong Party*','*Invalid Number*','*Fax Number*'}>} Reference)
PFA.
Use double quotes in set analysis to perform a search, so instead of
Comment={'*Uncontacted*','*Wrong Party*','*Invalid Number*','*Fax Number*'}
use
Comment={"*Uncontacted*","*Wrong Party*","*Invalid Number*","*Fax Number*"}
Use double quotes in set analysis to perform a search, so instead of
Comment={'*Uncontacted*','*Wrong Party*','*Invalid Number*','*Fax Number*'}
use
Comment={"*Uncontacted*","*Wrong Party*","*Invalid Number*","*Fax Number*"}
For what it's worth, more on set analysis quoting and examples on:
And the always-learn-something-new from our beloved HIC
Thank you very much for the insight Miguel.