Browse Tool to NOT display null value

[anle_airliquide]

I have a data sheet that I need to view in browse tool. I know that browse tool give you little summary on each column.
This is helpful, however it includes the NULL/ EMPTY cell and counted it into the percentage too. How do I "ignore" the null

In this example: CA state would have 1 "NOT PAID" (50%) and 1 PAID (50%) - total of 2 values . However the Browse Tool includes the null value too, making "NOT PAID" is 1 out of 5 (20%) and so as the "PAID"

Please help.

|
Thank you

[AngelosPachis]

Hi @anle_airliquide ,

As far as I'm aware off, the browse tool will give you a profile of your whole dataset so there is no way to ignore the nulls with a browse tool.

There might be other ways to achieve this manually, but without the convenience that the browse tool provides.

Cheers,

Angelos