Add Percentage to divide by 0 error in formula column

[Raeeee (Chiang)]

I am trying to calculate the accuracy rate (%) using {# of corrected work} devide {# of reviewed work}

With an old thread I found a formula in the forum that can resolve the error in result. However, if I changed the formula, the error pops up again in the accuracy column.

e.g. 20% instead of 0.2%)
2(# of corrected) / 10 (# of reviewed) = 0.2 (accuracy rate)
I need the result to be 20% instead of 0.2%

I am hoping someone can help or shed some lights here! Many thanks.

Here’s the formula I found posted by Jim Correll
The first, make all parts of a formula always work:

IF(AND({column1}<>0,{column2}<>0),{column1}/IF({column2}<>0,{column2},1),“”)

Second, use the DIVIDE function instead of the operation:

IF(AND({column1}<>0,{column2}<>0),DIVIDE({column1},{column2}),“”)

[JCorrell (Jim - The Monday Man)]

@Raeeee

Percent by definition is parts in 100. So, often, depending on context to the proper representation, you must multiply the result by 100 to show the value correctly.

---

Jim - The Monday Man
Update Magic #1 – New update enhancement toolbox
Column Magic – The magical columns toolbox
We Create Custom Apps, Integrations & Automations for monday

[Raeeee (Chiang)]

Hi @JCorrell

Thanks for your reply. I used below formula to show the value. However, if the data is “0”, it shows error.
IF({Reviewed (#)}=0,0,IF({Processed (#)}=0,0,((1-DIVIDE({Revised (#)},{Reviewed (#)}))*100)))

Any ideas of how to make “0=blank” after multiple 100? Thank you so much for your help.

[JCorrell (Jim - The Monday Man)]

@Raeeee

I do not understand what you mean by “Any ideas of how to make “0=blank” after multiple 100?”

It is unclear why the DIVIDE() is not working here.

Try this:

IF(AND({Reviewed (#)} > 0, {Processed (#)} > 0),
   ((1 - ({Revised (#)} / IF({Reviewed (#)} > 0,
      {Reviewed (#)}, 1))) * 100)
   , 0)

---

Jim - The Monday Man
Update Magic #1 – New update enhancement toolbox
Column Magic – The magical columns toolbox
We Create Custom Apps, Integrations & Automations for monday

[Raeeee (Chiang)]

OMG. It works! This is exactly what I was looking for. You are definitely a rockstar.