Hi Team,

I’m currently working on building a Balance Sheet in Zoho Analytics across different entities, with a common base currency of USD. I receive USD conversion values on a daily basis, and my requirement is to always capture the most recent available conversion rate from the data.

For example, if the report date is 04-06-2025, I want to retrieve the latest available USD conversion rate for that specific date.

Additionally, I need this logic to be dynamic so that whenever I apply date filters in the Reports tab, the most recent conversion value for the selected date is automatically used.

Could you please guide me on how to implement this in Zoho Analytics?

Thank you!