Filter Column on Mulitple Decimal Points

Filter Column on Mulitple Decimal Points

pendaspendas Posts: 1Questions: 1Answers: 0

I am using the range filter to enable filtering on decimal points. The code I have will only filter on the first instance of the decimal point and nothing after it. For example i am able to use my code to filter on the first number after the decimal in 470.6.00, but not more than that. So if I search for 470.6.1 as the min value 470.6.00 appears, even though it is under the min. Any thoughts on how I can get the code below to filter after the next decimals?

Sample of what I have here:
https://jsfiddle.net/t13zLLLc/28/

Answers

  • kthorngrenkthorngren Posts: 20,147Questions: 26Answers: 4,736

    You are using parseFloat() which returns a flowing point number (one decimal). Everything after is dropped. I would look at using the string split() method to split the strings at the periods. Then do the range comparisons. It would take a bit of code to accomplish.

    Kevin

This discussion has been closed.