Hello Geoffrey

Thank you for your purchase.

The first column is properly saved as an integer (you only need to remove the thousand separator from column's settings), but the other two columns don't seem to be integers, but floats.

When I take a look at your spreadsheet, the issue may be coming from the formatting applied. Try using this spreadsheet:

https://docs.google.com/spreadsheets/d/1yMVEcUwkgnSRFQCM6bBT4bfO70NGOSqs74jcsskl81c/edit?usp=sharing

That should cause no issues with wpDataTables, and you can add $ as a prefix in second and third column. Also, make sure the number format in wpDataTables settings are the same as they are in the Google Spreadsheet.

Hi again Geoffrey

Did you go into wpDataTables settings, and change the number format to what you need it to be?

Hello again Geoffrey

I don't mean if you changed it to Integer in column settings. You said the numbers came through in an integer column but the decimal separator is wrong.

Go to wpDataTables Settings and change the format of the numbers:

That has to work with the Spreadsheet I shared with you.

You're welcome, Geoffrey

Glad I could be of service.

If you have any further questions or issues, please feel free to open a new ticket, and we'll gladly help.

Hi again Geoffrey

It seems you have $ as the prefix in those columns.

Since that symbol is not an integer nor a float, the data is returned as invalid. You need to remove the $ sign from "Quotes" and "Holdings" columns, and only leave the data (floats). Then, in wpDataTables' column settings, you can add $ as a prefix.

Hello again Geoffrey

This can only be achieved with Advanced Filtering, adding a custom row CSS class to the column where the condition is 0.

However, that would not be a very good solution, because CSS would only hide the row from the screen, but it would still be there, so if you are displaying 10 rows, and you have 10 rows that have 0 in the "Holdings" column, the first page in the table would be blank.

Since the data is being pulled from the Google Spreadsheet, a better approach may be if you create another sheet (tab) in the same spreadsheet, and then pull only those rows where "Holdings" consists of a number higher than 0. Then, you would be able to create a new wpDataTable using the URL of that second tab, and display the data from it, coming already filtered in the form.