8 Replies Latest reply: May 12, 2017 5:06 PM by Cassandra Baqir RSS

    Dupes

    Cassandra Baqir

      This should be easy so I don't know why my brain can't get there.

       

      I have a list of providers by facility. I need a table/pivot chart that shows those that are duplicated (based on NPI number) at the same facility. I can get =count( NPI) to show counts but I only want the provider info listed if the count > 1.

       

      I would think the conditional expression =count(NPI)=>2 would work but I still see providers with only one occurrence at a facility.

       

      For example, I only want those with >2 in this chart and the total to reflect that.

       

      5-12-2017 1-22-31 PM.jpg