I have a data set which includes local currency amount and the equivalent amount in EURO. I calculated the FX rate (FX Rate) based on these 2 and compared the difference (FX Rate Diff) with the Central Bank data set rates per date (Selling Rates). The following step is to identify if there are any difference in FX on the same date. If there are differences, then check Central Bank FX rate of previous day and calculate the difference. Any help is appreciated!
Hi @RyanCuriel1,
I'm not sure if I am understanding your question fully. Assuming that the requirement is
If current day's [FX Rate Diff] = 0, compare the [FX Rates] of current day with the [Selling Rates] of previous day
you can use a Multi-Row formula to calculate [Previous Day Difference].
IF [FX Rate Diff] = 0
THEN ''
ELSE [Row -1: Selling Rates] - [FX Rates]
ENDIF
Hope this helps.
It will be great if you can provide sample data and we can build a sample workflow.
Cheers,
Lelia
Could you share a sample data with what you expect to have 🙂
It will help us provide the solution.
Regards