can you recreate the same issue using sample store data and attach the workbook
Try using if not null function and try to achieve the above problem.
if the data filed is null assign zero else assign the data fields value.
As i understand your request you want to count all responses null and other values.
You can do FLOAT(COUNT(ZN([CALCULATED FIELD 1)))
ZN converts nulls into zeros which are considered by the COUNT() function.
I guess he want to do this "Count() function is not parsing out the blank fields."
He want to eliminate the blank fields he doesn't want to count them.So if not null function will help him i guess.
Correct me if i am wrong.
I was a little confused about this too.
The COUNT() function ignores null values by default so this shouldn't be an issue.
That's the trouble I am running into, the COUNT() function is not culling out the null values, but instead counting them. I will try the not null function and see if that produces a desirable result.
Thanks for taking the time!
I was able to get get rid of the non-public info and post the workbook.
1 of 1 people found this helpful
So Excel is probably lieing to you about what is actually in that field.
Try doing this...
When "10" then 1
When "9" then 1
When "8" then 0
When "7" then 0
When "6" then 0
When "5" then 0
When "4" then 0
When "3" then 0
When "2" then 0
When "1" then 0
Excel can have all kinds of strange characters in a cell. Try converting ito a csv and inspecting the data elements to see if this is happening.