JavaScript Having problems with NaN in datasets

[Milton]

Hi All,

First post here.

I am having problems with NaN in Table Data in datasets in javascript.

I have a database that has been created in Filemaker, which is then converted to excel and then pasted into the table for my web page.
All the data including any empty cells display correctly in my datatable.

Any data that I have extracted to constants shows up correctly, but any data extracted that has empty cells returns NaN in the datasets for a chart.

Is there a way to not include empty cells in the dataset?

There are 3 datasets, each with 44 TD's for each table row.

As an example, the following is a constant that shows up correctly in a paragraph.

const gamesThisYear = cells[1].innerText;

And the constant that returns a correct value if there is a number in it, but NaN if it is empty is:

const WK1_TH = parseFloat(cells[13].innerText);

Any assistaance wold be extremely helpful.

Regards

Milton.

 

[Johna]

Hi there, the reason why it's returning NaN (meaning not a number) is because you're trying to convert a non-existent or empty value (undefined or null) into a floating-point number, and well, the result isn't a number.

Is there a way to not include empty cells in the dataset?

To completely filter out any empty cells, you could use the Array.filter() method to filter out any null values:

const filteredCells = cells.filter((cell) => cell.innerText != null);