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
------------------------------
Sign up
Already have an account? Login
Login to the community
Login with Quickbase US – quickbase.com Login with Quickbase EU – quickbase.eu
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.