How to Calculate a Pharmacy's Effective Aberrancy Rate
Short answer
Your effective aberrancy rate is your cumulative aberrant share for the month so far. You calculate it by dividing aberrant totals by overall totals, either in paid dollars or in claim count.
The steps
- 1.Pull your claims report for the month with all insurances included.
- 2.Identify matched claims by comparing normalized NDC candidates with the analyzer's versioned reference set.
- 3.Sum total paid dollars and aberrant paid dollars for the month.
- 4.Divide aberrant paid by total paid for the dollar-test rate.
- 5.Repeat with claim counts for the claim-count-test rate.
Read it as a rolling number
The rate is cumulative, not a daily average. Add each day's totals to the running month and recompute; the current standing is the latest day's rolling value.
The calculation at a glance (illustrative)
| Input | Dollar test | Claim-count test |
|---|---|---|
| Month-to-date totals | $64,000 total paid | 900 total claims |
| Aberrant portion | $8,320 aberrant paid | 45 aberrant claims |
| Effective rate | 8,320 ÷ 64,000 = 13.0% | 45 ÷ 900 = 5.0% |
| Reading | Higher on dollars — a few costly claims drive it | Calm on frequency |
Scope and limitations
This article is general product information, not legal, clinical, contracting, audit, or dispensing advice. PharmaFix uses the supported fields and bundled reference data described in the product; it does not speak for any payer or guarantee that a payer will calculate or act the same way. Review current network documents and obtain professional advice where appropriate.
Worked example
Month-to-date: total paid $64,000, aberrant paid $8,320. Dollar-test rate = 8,320 / 64,000 = 13.0%. If total claims were 900 and aberrant claims 45, the claim-count rate = 45 / 900 = 5.0%. This pharmacy is higher on dollars than on count, a sign that a few higher-cost aberrant claims are driving the dollar figure.
Illustrative figures only. Your numbers depend on your own volume and mix.
Common mistakes
- Averaging daily percentages instead of dividing cumulative totals.
- Matching NDCs in only one format, so hyphenated or 10-digit codes are missed.
- Leaving out claims from other insurers incorrectly, or including the wrong month.
How PharmaFix helps
PharmaFix computes the cumulative rate for you on both tests, day by day, from your existing export, and shows the single high-dollar claim that can move the dollar test on its own. It helps you estimate and understand the report.
Frequently asked questions
Dollars or claims, which rate should I use?
Both. They answer different questions and can diverge. PharmaFix shows each so you see your full position.
What if my NDCs are formatted differently?
Normalize each NDC to 11-digit form before matching. PharmaFix does this automatically, including 10-digit padding and common variants.
Estimate your report's position against the 25% reference line
Current checkout is test mode. Upload only an authorized PrimeRx or Caremark report without direct patient identifiers. PharmaFix calculates report-based rates and is designed not to retain report rows or results.