Number to boolean format help

Options
ankulkarni
ankulkarni Member, ALL USERS, Community Member Posts: 5 Contributor

Hi team, 

Looking for help- i have a column with number format which shows currency value ( total) which takes FX rates into account as well . e.g $2,000,000 and so on... now i want to use filters which will give me  projects having valuation more than 1,00,000 

i created a boolean filter and tried to change the format for currency value, it is not taking into account , can someone guide on how this can be achieved

 

Thank you