Juan Vaca Posted February 5, 2019 Share Posted February 5, 2019 Hello, I am trying to do a SN([column1],[column2]) but column1 has "-" that is filling the null value with. how can I go in there are remove the "-" so the SN function can do its job Link to comment Share on other sites More sharing options...
Harshith Reddy Musku Posted February 5, 2019 Share Posted February 5, 2019 Hello, I assume this is a cross table In cross table, nulls are automatically filled with '-'. You can change this from here -Cross table properties->Appearance->Set 'Display cells with no data' to 'Blank' Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now