Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
Grid Column Filter with formatter value


We have a column that comes from database as a value between 0 and 1. We use a formatter function for the column to make it a percentage (between 0 and 100) but when trying to filter for instance a 100, it does not show any results regardless that we have values for 1 in the data source. 

This is the function we use to format the column: 

And this is the column definition:

These are the rows in the grid: 

And this is the result when filtering the IFC % column with 100:

If we filter the IFC % column with 1 it works as expected:

Is there any way a grid column can be filtered (from the filter row) using the values from a formatter function instead of the source? 

Thanks in advance.