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

Answers

  • @OmkarKoch 

     

    Can you please show a picture of this?

  • Hi @OmkarKoch,

     

    It's working for me. Please check below.

     

    1. Before deleting #3

    shreyashree_0-1651756199838.png

    2. After deleting #3

    shreyashree_1-1651756273934.png

     

    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.