Sorting Percentages with N/A Values

justinT

Hi!

So I'm trying to sort columns that have a percentage in them if a calculated number is valid, otherwise they contain the string "N/A". Is there a way to use the percent sorting plug-in as well as some other sorting plug-in to get "N/A" sorting with the rest of the values?

Currently I have the percentage columns being built like this:

{ "sTitle": "YTD I/E Ratio", "sClass": "lossRatio tdright thcenter", "sWidth": "3%", "sType": "percent"}

They are being built in a JavaScript file and I making the call to "//cdn.datatables.net/plug-ins/1.10.12/sorting/percent.js" in my HTML file.

If anyone has further questions about anything that I'm doing, please let me know.

I would like to thank everyone in advance for their help.

Thanks,
Justin