Forum Discussion
Weighted Ratio Avg
I'm attempting to write a formula for excel that provides weighted averages for bed fill rates. I have a column which contains program capacity and a column that contains bed fill rate for each program. It's my understanding that to calculate the average of these ratios I must first take the bed patient ratio of each program and multiple that number by the weight which in this case is the capacity. I then need to take the sum of the ratio* weight and divide that by the total weights which in this case is the total capacity of all the programs. I believe the formula looks like this. Can someone show me what the DAX formula of this would look like or the calculated field for standard pivot table?
1 Reply
If you share the sample file it will be much easier to suggest the solution. Otherwise someone of us shall to generate such file from scratch, create model, add formulae to it and test with result. Without warranty that created model is exactly what do you need.
