Hi Team,

I’m looking to implement a feature that captures the conversion rate based on the filters applied. By default, it should fetch the most recent conversion rate, and when a filter (such as a timeline filter) is applied, it should return the conversion rate corresponding to that specific period.

The issue I'm currently facing:

I have a Transaction table (Accrual Transactions) where the conversion rate is mapped alongside the transaction date. The challenge is retrieving the correct conversion rate based on this setup, especially when applying filters.

Additionally, there are multiple types of conversions involved — for example:

• PHP to USD

• INR to USD

• MYR to USD
  and so on.

I need a reliable way to determine and return the appropriate conversion rate for each scenario based on the selected filters.