KPI calculator

Promotion Rate Calculator

Enter your values to calculate Promotion Rate. 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.

Promotion Rate books Books that help you understand Promotion Rate and related business metrics more deeply. Explore resources → Promotion Rate audiobooks Audiobook searches for learning Promotion Rate while commuting, walking, or working. Explore resources → People analytics resources Excel-focused resources for building KPI trackers and dashboard workflows. Explore resources → Recruiting analytics resources Practical resources for turning Promotion Rate into reports, dashboards, and business decisions. Explore resources →

Calculate Promotion Rate

Employees Promoted Total Employees

Result—

Formula

Employees Promoted / Total Employees

Excel formula

=IFERROR(B2/C2,0)

Power BI DAX measure

Promotion Rate =
DIVIDE(
    [Employees Promoted],
    [Total Employees]
)

Read the complete Promotion Rate formula guide →