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.

     

     

Welcome!

It looks like you're new here. Sign in or register to get started.
Sign In