Skip to Content
0
Sep 15, 2023 at 12:55 PM

Replacing 0 with Blank and hiding columns having 0 values

53 Views

Hi Team,
I have a requirement 1) where the blank rows must be hidden and 2) where we are getting "0" then it must be replaced with Blank/Empty

To achieve the first requirement i went into the table format and removed the checkboxes:

image.png

by doing this i was able to remove the empty rows but now i cant replace the columns having 0 with blank. If i am unselecting the other options of removing the "rows with empty values" then its again displaying the empty rows. Below is the screenshot where i need to replace the 0 with Blank.

image.png

Please suggest the ways to replace the 0's with blank.

Thanks

Attachments

image.png (32.7 kB)
image.png (17.7 kB)