Skip to main content
Question

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
------------------------------
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+24
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
------------------------------