I have a saved search with a Formula(text) that is grouped where I need to have a blank space when none of the Cases are found. Right now I am getting

-None-

. I tried using

ELSE ' ' END

and also

ELSE NULL END

but am still getting the

-None-

. How can I have this be blank?

Use NVL({fieldname}, ' ')

Thanks!

ELSE ' ' END should also work, but I guess you CASE statement never comes to this option.

It does. I believe the reason it shows - None - is because of the grouping, On ungrouped fields it is blank when using ELSE ' ' END