4 Replies Latest reply: Sep 13, 2016 4:35 PM by Ankit Chaudhary RSS

    Filtering of data.

    Ankit Chaudhary

      I have the code as given below,The code is working fine ,however I don't want other call detail skill name apart from the one mentioned in the condition.I am getting Inbound for all the values given below,but i am also getting other value which I have not mentioned as Inbound.How can I get rid of them and just display the values which I have here.

       

       

      If("Call Detail SkillName" = 'Trial Portal Level 1' or "Call Detail SkillName" = 'Knox Portal Level 1' or "Call Detail SkillName" = 'Signature Portal Level 1'or "Call Detail SkillName" = 'Premier Portal Level 1' or "Call Detail SkillName" =

      'Other Portal Level 1','Inbound',"Call Detail SkillName")))

        • Re: Filtering of data.
          Stefan Wühl

          As far as I see, the expression should only return Inbound for the listed skill names.

           

          (You could use Match() function instead of your OR'ed comparisons or an Mapping table approach instead, but that's not your issue).

           

          Could you post some more details about the context you are using this expression in?