Section Access Reduction field includes NULL values

[datagrrl]

Hello-

I have an issue with an application. I am trying to implement Section Access for the first time.

I have users need access to all regions, but there is some dirty data with no (NULL) value for region.

If I use the "*" in the reduction field all records except for those with a NULL value in region are returned.\

I know it is more ideal to clean up the data, but the NULL regions actually mean something.

Any suggestions?

[nagaiank]

You may replace nulls with a meaningful non-null text

(e.g.  If(IsNull(Region),'Null-Region',Region) as Region)

and see if that helps your Section Access requirements.

[datagrrl]

Okay, I was wondering if that was the best solution. Thanks for your help.