and

CASE WHEN {whatevermyfieldis} = '- None -' THEN '' ELSE {whatevermyfieldis} END

You've just found a weird place of how NS handles grouping. If you just make another column and put the value as

''

, when NS does the grouping, it changes it to

- None -

. Your formulas are fine, just change them to a blank space, or anything except an empty string

ugh NS is dumb

yeah oh well is about the best you can feel about it

lol

that is idiotic, who wants

- None -

sitting there

- None - is worse than pretty much anything