Cumulate Function in numbered list

I am facing cumulate function issue for numbered list.

If unique index number of numbered list are #1 and #3 , without #2 (deleted for some reason), cumulate function fails to cumulate for list item with unique index number #3.

Please suggest any fix for this.

Regards,

Omkar

Accepted answers

All comments

rob_marshall

@OmkarKoch

Can you please show a picture of this?

shreyashree

Hi @OmkarKoch,

It's working for me. Please check below.

1. Before deleting #3

2. After deleting #3

The formula used is CUMULATE(Value, FALSE, Numbered) where Numbered is the name of my numbered list.

Let me know if you are looking for something else.

Quick Links

Can you help?

Unanswered questions

Has anyone taken a stab at Master Anaplanner Recertification exam yet?
Just curious :)…
Solution for indent diabled for hierarchical list when the page has more than two axis
Hello fellow Anaplaners, I have a question about the UX for Anaplan for hierarchical list. If I have a list with multiple layers, say P1, P2, P3, and P4, and the workpage had 2 axis, list and line items, in its vertical axis and time in its horizontal axis (see figure below) The list is shown without indentations, and may…
Best way to Architect Financial Statements in Anaplan for Scalability
I have seen two methods used to build financial statements and I am wondering what others have experienced in scalability/maintenance between the two or if there is a better approach. Assume that we have a flat data source for our general ledger within Anaplan. Our line item we are focused on within the source data is the…