I have an If - Then - Else formula that I am using to evaluate occurrences of internet browsers. I have one for each browser (IE, Chrome, etc...).

For 'true' the formula inserts a unique id. I have nothing for 'false'. When I summarize with a distinct count my result is X + 1. X for each correct unique id and the extra count is the one blank value that is being counted. I'm using distinct count-In actuality, there are hundreds of blank values for when a browser version does not exist.

So if there were 1900 installations of Firefox, my final count would be 1901 - using distinct count.

Is there a way to write my formula that will prevent the blank value from being counted in my summarization? Is there a way to change my summary so that it does not count the blank value?

I thought that I might be able to INSERT a null value when my formula returned false but I can't seem to get the syntax right (if one exists). I'm also not sure that it would still not be counted as a blank.

Any ideas are welcome.

Thank you!

Nmind...
I think I figured it out. I just embedded my original if then else formula into a new formula that subtracted 1.

DistinctCount ({@IS Explorer}, {@Region}) - 1

It works!

I do not recommend the -1 trick as it only works when you definitively have the else default value ("" for text or 0 for numeric) which is giving you the extra count (+1) in your distinctcount.