How to Step Rounding Percentage

TolerDo

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!

TolerDo

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.

Leroy Noriega

In your sheet toolbar, look for the highlighted icon below.

TolerDo

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, "--")

heyjay

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, "--")

TolerDo

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.