7 Replies Latest reply on Aug 14, 2018 8:54 PM by Deepak Rai

    Removing Duplicates for Productivity Calculations

    Kaitlyn Burns

      Hello! -

       

      I'm hoping there's a possible solutions to my issue. I am working on creating a provider productivity dashboard to show RVUs per clinical FTE broken down by specialty by quarter.

       

      My initial calculation: wRVUs/cFTE - This was giving me an inflated number based on calculations I had conducted previously in Excel.

       

      When looking at the full data, I found that for each quarter, each provider had 3 rows of data (i.e. July, August, September), and the calculation was counting their clinical FTE three times rather than once.

       

      Is there a calculation I can enter that will count all of the RVUs for all of the providers but will only count their clinical FTE once? 

       

      Thank you!