Forum Discussion

ChristinePratt1's avatar
ChristinePratt1
Qrew Cadet
3 years ago

Formula field doesn't display 0

Hello,

I have a simple formula field [Volume]/[Count] which gives me the average. 

The issue I'm having is if there is no volume and no count for a particular client, the formula field is blank instead of showing zero. I have checked and both the volume and count fields have the button checked to Treat blank values as "0" in calculations but the result still doesn't give me 0.

------------------------------
Christine Pratts
------------------------------

2 Replies

  • Well, diving by zero is not mathematically possible but No problem,

    IF([Count] >0  [Volume]/[Count], 0) 

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------
    • ChristinePratt1's avatar
      ChristinePratt1
      Qrew Cadet
      Thank you, Mark! That worked beautifully.

      ------------------------------
      Christine Pratts
      ------------------------------