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
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