4 Replies Latest reply: Feb 8, 2017 7:19 PM by Amanda Hamm RSS

    Match sort not working

    Sarah Nguyen

      Hello.

       

      I used the following expression under Sort section: Match(cpt4_code_id, '99201', '99202' , '99203', '99204', '99205')

       

      Works great:

       

      150c8aaefb0d486192b43052ad8f25f0.jpg

       

      However, when I select a filter for a specific provider name, the sort no longer works.

       

      76bbdba35edc4816894cb3b79f5ad754.jpg

      Measure 1:

      Count({$<cpt4_code_id={'99201','99202','99203','99204','99205'}>}cpt4_code_id)/Count(total{$<cpt4_code_id={'99201','99202','99203','99204','99205'}>}quantity)

       

      Measure 2:

      Count({1<cpt4_code_id={'99201','99202','99203','99204','99205'}>}cpt4_code_id)/Count(total{1<cpt4_code_id={'99201','99202','99203','99204','99205'}>}quantity)

       

      How come the order doesn't follow what is in the expression?

      Match(cpt4_code_id, '99201', '99202' , '99203', '99204', '99205')