How to Step Rounding Percentage
Below is a very basic formula actual/workset a to get the %achieved.
You can see that the two calculations are off one should be 33%, the other 20%
What is the best way to show the actual value, not the rounded value?
Thanks!
Best Answer
-
Ah! I figured it out. It was essentially a double-rounding error.
The formula in Workset A column was 22*0.25, now it's =rounddown(22*0.25)
Then when I apply the formula to the %Achieved column (actual/workset A) it's now accurate. Now I know I need to be more conscious about formulas when there are shared components.
Thanks pointing me in the right direction.
Answers
-
In your sheet toolbar, look for the highlighted icon below.
Leroy Noriega | Smartsheet SME | Independent Smartsheet Consultant
Core App, Project Management and System Administrator Certified🏅
E: leroy.noriega@yahoo.com | Linkedin Profile
-
Thanks — I already tried that — it only adds decimal places. It doesn't correct the formula result.
This is the simple formula I'm using: =IFERROR(Actual@row / [%Achieved]4, "--")
-
Im assuming that the formula
=IFERROR(Actual@row / [%Achieved]4, "--")
is in column Workset A, and you want to correct %Achieved column.What is your formula for the %Achieved column to show that it is 36% and 21%?
If formula for %Achieved is what you are looking for, I think should be
=IFERROR(Actual@row / [Workset A]@row, "--")
...
-
Ah! I figured it out. It was essentially a double-rounding error.
The formula in Workset A column was 22*0.25, now it's =rounddown(22*0.25)
Then when I apply the formula to the %Achieved column (actual/workset A) it's now accurate. Now I know I need to be more conscious about formulas when there are shared components.
Thanks pointing me in the right direction.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!