4 Replies Latest reply: May 24, 2013 10:06 AM by Steve Zagzebski RSS

    Set Analysis - Wildmatch within Count Distinct

    Steve Zagzebski

      In my expression below "Set Analysis 1" works fine. I tried to modify slighly to add the wildmatch function to count only the distinct Benefit Package Codes that begin with HMO, Not sure what I am doing wrong but "Set Analysis 2" doesnt work.


      Set Analysis 1:

      count({$<[Group ID] = {'=COUNT(DISTINCT [Benefit Package Code]) > 1'}>} distinct([Group ID] ))


      Set Analysis 2:

      count({$<[Group ID] = {'=COUNT(DISTINCT wildmatch([Benefit Package Code],"HMO*")) > 1'}>} distinct([Group ID] ))