Case - % Increase on Previous List Item

Hi All,

I am working on one use case where need to calculated the value on the basis of previous list item. Module doesn't have a time dimension. But I've created mapping module to identify the previous item.

Please see below screenshot for your reference.

Final Value = Previous (final Value)* % increase.

Can you suggest any idea to do this?

Thanks in Advance
Ashutosh

Accepted answers

andrewtye

Hi @Ashutosh

What would probably do is create a time period and then map your list to that and can then use the previous function and then bring the values back again. Does require two look-ups but is nice and simple and avoids circular references from happening.

I'm sure that there's a way to do it just on the list itself but is probably less clean than the above

Andrew

All comments

pyrypeura

Hi,

If you map your list to time dimension in a way so Escalation 1 = Day 1, Escalation 2 = Day 2 and so on you can use lookup to get these to a module by time dimension and then use previous to get values. Then you can lookup values back to your original model.

Dikshant

@Ashutosh,

If list has less list items like 10,20 and will not increase quite often then you can maintain this mapping manually and use LOOKUP function to get the final result.

Which list are you talking about in this example - Escalation List or the one which says List 1 ?

Ashutosh

@dikshant,

The escalation list I am talking about.

andrewtye

Hi @Ashutosh

I'm sure that there's a way to do it just on the list itself but is probably less clean than the above

Andrew

Dikshant

@Ashutosh, If it's Escalation list and looks like it has only 10 items, then you can manually maintain it…

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.…