Calculate Quota Attainment
Result—
Formula
Actual Sales / Sales QuotaExcel formula
=IFERROR(B2/C2,0)Power BI DAX measure
Quota Attainment =
DIVIDE(
[Actual Sales],
[Sales Quota]
)KPI calculator
Quota Attainment Calculator
Enter your values to calculate Quota Attainment. Use the formula and examples below for Excel, Google Sheets, Power BI, and dashboards.
Affiliate resources
Ideas for You
Useful learning resources related to this page. As an Amazon Associate, this site may earn from qualifying purchases at no extra cost to you.
Quota Attainment books
Books that help you understand Quota Attainment and related business metrics more deeply.
Explore resources →
Quota Attainment audiobooks
Audiobook searches for learning Quota Attainment while commuting, walking, or working.
Explore resources →
Sales dashboard resources
Excel-focused resources for building KPI trackers and dashboard workflows.
Explore resources →
Sales management resources
Practical resources for turning Quota Attainment into reports, dashboards, and business decisions.
Explore resources →