To show Percentages of a Total in formula

Quick question. if this following formula brings back a numeric value how can i expand the equation to return a percentage of a total. I tried dividing the entire formula by the total row but that didn't work. Any advice. i want the chart below to return percentages. for example, the first row the '3' should say 1 - which i would then convert to percentage and it would reflect 100.
=COUNTIF({S&0- Transformation PMO Range 5}, [Column7]30)
Answers
-
Hi @Khanambano,
I would suggest doing as you suggested and dividing the value by the Total column.
=COUNTIF({S&0- Transformation PMO Range 5}, [Column7]30) / [Total]@row
You should get 1, and decimals for the rest of the values. This should work If you change the column to a percentage format using the Expanding three dots on the tool bar ... and selecting the percentage symbol.
Hope this helps!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 67.9K Get Help
- 474 Global Discussions
- 208 Use Cases
- 517 Announcements
- 5.6K Ideas & Feature Requests
- 87 Brandfolder
- 157 Just for fun
- 84 Community Job Board
- 521 Show & Tell
- 36 Member Spotlight
- 3 SmartStories
- 309 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!