6 Replies Latest reply: Oct 11, 2017 5:56 PM by Marco Wedel RSS

    Count For Pick and WildMatch

    Sweeyan Sy

      Unable to recount the word after it have been count in bar chart.

       

      Labels
      ITSDM; UAT
      ITSDM
      ITSDM
      ITSDM; UAT
      ITSDM; UAT

       

      =Pick(WildMatch(Labels, '*ITSDM*', '*UAT*'), 'ITSDM', 'UAT')

       

      The bar chart should be

       

      ITSDM 5

      UAT 3

       

      But the error now is

       

      ITSDM 5

      UAT 0