I am trying to create a formula field to count if there are any blank values on Number field.

My formula is :

if(ISBLANK(Number Field),1,0)

However, it is always coming as '0' even if the number field is having some value in the record.

Please advise as to where I am going wrong.

Attribution to: Vimal Desai

Possible Suggestion/Solution #1

One assumption Vimal Go to the formula field edit it and scroll down to the last and see if you set Treat blank fields as zeroes if you did set it to "Treat blank fields as zeroes"

Set it to :

Treat blank fields as blanks

Hope this solves.

Attribution to: Rao
This content is remixed from stackoverflow or stackexchange. Please visit https://salesforce.stackexchange.com/questions/3728