Need Help with Divide 0 Error

Platform discussions
1

Trying to perform a simple formula to determine percentage. Sometimes my Proposal Created Fag will contain a 0 when the deal signed flag has a 1 and this throws an error for dividing by 0. Would like the error to be replaced with a 0.Any suggestions?

SUM({Deal Signed Flag}/{Proposal Created Flag}*100)

image
image426×340 8.3 KB

2

Hi @ShaunPKing79,

Not sure why you are using SUM with only one argument, but for the rest of the formula try:

{Deal Signed Flag}/IF({Proposal Created Flag}>0,{Proposal Created Flag},1)*100

 

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.

1 Like
3

I tried th IF function and was close, but your suggestion works. Thank you!