Cumulate Inquiry

Highlighted
Community Boss

Cumulate Inquiry

Hi,

 

I am currently supporting a project Budget Run and I come across a formula in excel where I thought was easy and yet kind of confusing. See on the attachment. 

I am trying to calculate the Recognized NSA on the template. The formula in excel seems to be adding up each previous month. I tried using the previous command and it does not seem right or I was using it incorrectly. The clients template has a lot of this formula so I appreciate it if you anyone can point me in the right direction.

 

Thanks in advance

 

Regards,

 

Note: Apologies for the attachment I cant seem to paste on the Body a picture that I saved.

 
8 REPLIES 8
Highlighted
Master Anaplanner/Community Boss

Re: Cumulate Inquiry

@Jsdeloria21 

 

Attached mock up isn't clear.Can you please add the same example in the workbook and paste it here

 

Thanks,

Misbah

Highlighted
Community Boss

Re: Cumulate Inquiry

Hi Misbah,

 

 

Please see attachment.

 

 

Regards,

Highlighted
Community Boss

Re: Cumulate Inquiry

image.pngPlease explore the moving sum function.

 

https://help.anaplan.com/anapedia/Content/Calculation_Functions/All/MOVINGSUM.html

 

Thanks

Arun

Highlighted
Community Boss

Re: Cumulate Inquiry

Hi Arun,

 

Please see attachment. It includes the previous inquiry.

 

 

Regards,

Highlighted
Community Boss

Re: Cumulate Inquiry

You have already cumulated the "Percentage of completion" in "Cumulative" line item, you may want to use this "Cumulative" line item in your Recognized NSA.
Currently you are doing MOVINGSUM on "Percentage of Completion" with 0 bucket, which means it is not cumulated.

 

Thanks

Arun

Highlighted
Community Boss

Re: Cumulate Inquiry

HI Arun,

 

Understood, will try to change the formula. Is there a reason why it is moving on Mar 20.

 

Regards,

Highlighted
Master Anaplanner/Community Boss

Re: Best Malaysian Curry Past

@mamalams 

 

What's this? Nowhere relevant to the post.

@ArunManickam @nathan_rudman  Looks fishy.

 

Thanks,

Misbah

Highlighted
Master Anaplanner/Community Boss

Re: Best Malaysian Curry Past

Anytime you see a post like the above, please report it to the community team - they will delete the post and ban the account

2019-11-19_11-22-46.png

We don't want this nonsense on our community

David