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 ...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendWell, 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
------------------------------
IF([Count] >0 [Volume]/[Count], 0)
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
Thank you, Mark! That worked beautifully.
------------------------------
Christine Pratts
------------------------------
------------------------------
Christine Pratts
------------------------------