Cumulate calculation but skip 1st item

Do you have any ideas to calculate this; what I need?
If I make a line item called "for lookup" and use LOOKUP formula, I can do this.

However I need to fill in "for lookup" manually.
I simplify the case here and "Figure" should be calculated using "What I need", so I cannot use "Figure" since it becomes circulation…

Accepted answers

All comments

Amaya

Hello,

Normal Cumulate - Figure = What you need, although only in this case.
Subtracting the current figure from the cumulative total gives the cumulative total up to the previous one.

What do you think?

Amaya

seymatas1

Hi @Naoto,

Amaya's solution is practical and works perfectly in this case.

You can try this one if you need to develop a more generalized solution.

You can enter a shift parameter.

I hope this helps. 🌷🙂

Seyma Tas

Naoto

Thank you all!

considering your ideas, I found out another way to solve my issue.

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