# Percentage calculation formula

**URL:** <https://community.hubspot.com/t/percentage-calculation-formula/140515>\
**Category:** 💬 RevOps Discussions\
**Tags:** marketingops\
**Created:** [October 3, 2025, 1:56pm UTC](https://community.hubspot.com/t/percentage-calculation-formula/140515 "2025-10-03T13:56:41Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![MSerebriannik](https://avatars.discourse-cdn.com/v4/letter/m/e79b87/32.png) [@MSerebriannik](https://community.hubspot.com/u/MSerebriannik)\
**Post date:** [October 3, 2025, 1:56pm UTC](https://community.hubspot.com/t/percentage-calculation-formula/140515/1 "2025-10-03T13:56:41Z")

</div>

Hi all,  
May I ask for help: I need to calculate the persentage of all number rows from total by creating new column with formula.  
What fields to apply? Variables are below on the screenshot:

 ![157381iC1D8BC414D5C2AEA.png](https://d2qpr2jzcazej7.cloudfront.net/original/3X/4/2/42a3f7595fd294b55ea3c1dd758b70eff31df370.png)

---

<div class="post-metadata">

**Author:** ![chighsmith](https://avatars.discourse-cdn.com/v4/letter/c/77aa72/32.png) [@chighsmith](https://community.hubspot.com/u/chighsmith)\
**Post date:** [October 3, 2025, 6:24pm UTC](https://community.hubspot.com/t/percentage-calculation-formula/140515/2 "2025-10-03T18:24:59Z")

</div>

Hi @MSerebriannik,  
Thank you for posting to the Community!  
I’d like to tag in some of our Top Contributors to see if they have any suggestions on this -- Hi @colinwitt @AdamLPW @warrendavey Happy Friday! Do any of you all have any ideas for @MSerebriannik?  
Thank you!  
Cassie, Community Manager

---

<div class="post-metadata">

**Author:** ![d-lupo](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/d-lupo/32/31044_2.png) [@d-lupo](https://community.hubspot.com/u/d-lupo)\
**Post date:** [October 6, 2025, 5:31pm UTC](https://community.hubspot.com/t/percentage-calculation-formula/140515/3 "2025-10-06T17:31:51Z")

</div>

Hi @MSerebriannik

According to the [official documentation](https://knowledge.hubspot.com/reports/create-formula-fields-in-the-custom-report-builder?hubs_content=knowledge.hubspot.com/de/reporting-and-data/topics&hubs_content-cta=uiLinkDark):  
_“Formula fields perform row-level math on your data table, which means the calculation is performed on a row-by-row basis. This is different from aggregate math, which is performed on the column level.”_

This means it’s not possible to calculate percentages relative to the total directly within a table using formula fields in your current setup.

My recommendation:  
Use a donut or pie chart instead of a table. These chart types automatically display percentages for each segment, which achieves the desired outcome without needing complex calculations.

![]()

Let me know if that helped you 😄

---

<div class="post-metadata">

**Author:** ![DLeo9](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/dleo9/32/212059_2.png) [@DLeo9](https://community.hubspot.com/u/DLeo9)\
**Post date:** [December 16, 2025, 2:43pm UTC](https://community.hubspot.com/t/percentage-calculation-formula/140515/4 "2025-12-16T14:43:07Z")

</div>

To calculate a percentage, use this formula:

**Percentage = (Value ÷ Total) × 100**

In a new column, divide each row value by the total and multiply by 100. For example, if the value is in **B2** and the total is in **B10** , use:

=B2/$B$10\*100

This method is also commonly used in tools like a [**net salary calculator**](https://calcolostipendionett.it/), where individual deductions are calculated as a percentage of total salary.