Formula not showing 0 when one column is 0 results

Platform discussions
, ,
1

I have a formula just looking at a couple of columns to show a % result. However, when one of the columns is a 0 result then the formula is showing " " and I cannot get it to show the 0. Formula:

IF(AND({Calls Answered}<>“”,{Calls Answered}>0),ROUND({Calls Answered}/MAX({Calls Attempted},1)*100,“0”),“”)

eg. Calls Attempted = 2 and Calls Answered = 1 it showing 50%.
Calls Attempted = 2 and Calls Answered = 0 it is showing blank, but I need it to show 0

Thanks,

2

Hi Andy,

Remove the last “” and replace it with 0.

 
 

Want to take your formulas to the next level? Try the Advanced Formula Booster, the app that reinvents formulas in monday.

  • Create formulas without using the Formula column (and avoid its limitations)
  • Build formulas involving data from the previous item, the next item, the sub-items, the parent item, even items in the same group or the same board.
  • In one formula, update multiple columns from multiple items.

Check our blog for real use cases.

3

Hi,

I had something similar which I’ve modified to match your code. I think I’ve done it correctly. The idea is to explicitly state that 0 = 0%

IF({Calls Answered} = 0, "0%", IF(AND({Calls Answered} <> "", {Calls Answered} > 0), ROUND({Calls Answered} / MAX({Calls Attempted}, 1) * 100, 0) & "%", ""))

Hope that helps or at least points you in a good direction.

4

Hi, thank you for the reply. I had tried a few things but that is annoying it is so simple.

That looks closer to how it should look, however, the only thing that would make it even better is if it would ignore any pulses with NULL in a result and count 0 as 0, so treating Null and 0 as different? Any idea if that is possible