Retrieving last non zero value for daily exchange rates

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!

Accepted answers

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

All comments

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

Quick Links

Can you help?

Unanswered questions

Sorting General List
Hi, I wonder if there's a way I can sort my general list alphabetically. The list is used as a drop down menu in a line item module and I want the drop down menu to be easy to navigate. I've already tried the Order List action. I already have a module with a text-formatted line item based on that list. But when I try to…
Predefaulting A Feild in ANAPLAN
Hello Anaplan Community, I have a special requirement from a customer and would appreciate your input. Let me explain the situation: We have a hierarchy with three levels: Level 1, Level 2, and Level 3. Screen 1: Creation of Level 1 Items On this screen, the user selects a team. Based on their selection, an action runs to…
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…