Cumulate Function in numbered list

OmkarKoch
OmkarKoch
in Modeling

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

Tagged:

Answers

  • rob_marshall
    rob_marshall

    @OmkarKoch 

     

    Can you please show a picture of this?

  • shreyashree
    shreyashree

    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.

     

     

Categories