Retrieving last non zero value for daily exchange rates

NicholasValentinus

Hi,

 

I have a daily exchange rate module which store the daily rates for multiple currencies. I wanted to get the last non-zero value for each date for example we have daily exchange rates for 1 Jan 2021 but none for 2nd and 3rd of Jan 2021, so the daily exchange rates for 3 Jan 2021 should display the rates of 1 Jan 2021 since the last non-zero value for daily exchange rates is available at 1 Jan 2021.

 

 

Is there any workaround or solution for this requirement?

Any help is highly appreciated

Thank you!

nikmg

 

HI @NicholasValentinus ,

 

In your "Last Non Zero" line item you can write this formula to achieve this result.

IF Daily Rates <> 0 THEN Daily Rates ELSE PREVIOUS(Last Non Zero)

 

EX:

 

Best,

Nik

 

nmartinez

This would be extremely useful. yet the screen copy you made is not readable (too small) so i can't the formula and last non zero is not recognized. Could you provide the formula please

obaccobefrit

Having this would be of great assistance. The screen copy that you created, however, is not readable.
Regard,

Subway Surfers