Finding currency rate by date

1

Hi!

We have two different datasets: one with rates by date and currency and an other with different transactions. I want to merge the correct rate for each transaction by currency and date but if there is no rate at for a certain date we should use the last avalilable before the given date for that currency.
What is the best practice approach for these kind of issues?

Thanks in advance,
M

2

You can use the “Fill down” action to fill down empty cells that don’t have a conversion rate. Sort the table in the reverse order if you need to “fill up”.

3

Thank you, we managed it with a database trigger instead. Performancewise it’s better.