First off. Thank you for continuing to follow up on this for me.
All of my hands in the report are at the 6 max level, so setting the filter to 6max will make no difference in the data I posted in the picture above.
Also, the PPA number of 5.95 is the same on all reports on HM2, both in Leakbuster Reports and Non-Leakbuster Reports.
So, with the data all at the 6 max level and your revised reversed formula ...
Early UO PFR = 8.16
Middle UO PFR = 12.6
Cutoff UO PFR = 19.3
Button UO PFR = 48.6
PPA = (CO+BU)/(EP+MP) (19.3+48.6)/(8.16+12.6)=3.27
Again, this is different than the PPA in HM2 of 5.95.
But with the old formula ...
PPA = (BU)/(EP) (48.6)/(8.16) = 5.95
The numbers match exactly.
I'm not sure of what to say and I am a bit frustrated. I am using the proper values and when I follow your formula, they are not even close to the proper PPA number.
I'm sure you have test data bases. Can you set the filters up the way you want, plug your numbers into your formula and have it match the PPA number?
Thanks again for your solid customer service.