Formula with multiple rows

[Le18BR]

Hello, hope you’re doing well.

I have two tables that I’m trying to bring the following result.

Table 1 - Dates and Values
Table 2 - Dates and currency amount

I’ve used “joiner” with the dates criteria but the problem is that the currency value does not appear dates every 10 days.

To be clear of what I’m looking for is that the last currency value showing, repeats until the next one that already exists and then repeats the cycle again. The image below shows exactly the wanted outcome.

Thanks!

[aworker]

Hi @Le18BR

The -Missing Value- node fills the missing values of a precise column depending on a condition of your choice. In your case, the best condition shoul be to fill with previous row valid value, ie. the previous nearest cell containing your set currency value.

Hope it helps.
Best
Ael