Hi, Deepak –
I tried this, but it doesn’t provide the correct numbers.
Example: For FY2018 Q1 Podiatric Surgery, the total RVUs = 5,319.50 and the total cFTE = 3.8; therefore, I should be showing RVU/cFTE = 1,399.87
The formulas you’ve provided are giving me a total for FY2018 Q1 Podiatric Surgery of 4.0
Can you explain the logic about the ratio?
RVUs per FTE is used by our team in order to review provider productivity. We can use this ratio along with others including RVUs per encounter and procedures per FTE. We look at these numbers further when we look at service line issues such as costs and staffing.
That's Fine, But since your dataset is big, I am asking you How are you getting 1399.87. I Need to understand logic.
I’ll use FY2018 Q1 Podiatric Surgery for an example.
Below, you can see that each provider has 3 rows of data (July, Aug, Sept). In Excel, I would total the wRVUs for the months (5,319.50) and then divide this total by the total cFTEs for the providers (3.75). This would give me the RVU/cFTE of 1,418.53 for this service line during this time period.
However, in Tableau, it’s dividing each wRVU row by each cFTE in that row. So, it’s counting each cFTE three times rather than once, giving inflated numbers.
What I am hoping to see if there’s a calculation that can take the total wRVUs for the time period (quarter) and divide it just by the total of the 1st cFTE per provider (below).
I’ve been reading/trying out different calculations but haven’t seemed to find anything that works.
Thanks again for your help!
Here It Is:
You Need to Use This Calc To Get It and Since I used LOD, I added Filters to CONTEXT for LOD to Operate.
If it Helps, Pl Mark it Helpful and CORRECT to Close Thread
wRVU Dashboard_v10.2.twbx 622.7 KB