I'm running a quick report for all the items sold in our online shop, and some of the products / rows are coming back with a null field for the SUM().
I've gone through the column's filtering and conditional formatting (and documentation), and I can't find a way to hide a row were the value is = 0 (null).
i.e. I only want to display rows where there's a count of sold items.
Can you please advise if I can remove / hide rows for "null" field.
Hi Team,
I'm running a quick report for all the items sold in our online shop, and some of the products / rows are coming back with a null field for the SUM().
I've gone through the column's filtering and conditional formatting (and documentation), and I can't find a way to hide a row were the value is = 0 (null).
i.e. I only want to display rows where there's a count of sold items.
Can you please advise if I can remove / hide rows for "null" field.
Kind regards,
Miles
HI Miles,
Thank you for your purchase.
Can you please send me the link of that table so I can take a look.
Best regards.
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables
Hi Bogdan,
Don't worry, I've changed my query to convert all "NULL" fields to "0", the only return results ">0".
However it would be useful to be able to hide a row if any of the fields match a criteria... 0 for example.
Cheers,
Miles