Number to boolean format help

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

Answers

  • @ankulkarni 

    The simplest way to create your driver using the local currency is to use a Line Item Subset (LISS) or use a separate system module. Take your driver in the currency of your choice, run it through the exchange rates, and select the respective driver that matches the project currency. The Boolean will then be adjusted correctly for the exchange rate.