Highlighted
Contributor

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
Super Contributor

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

Contributor

Re: Cumulate Inquiry

Hi Misbah,

 

 

Please see attachment.

 

 

Regards,

Super Contributor

Re: Cumulate Inquiry

image.pngPlease explore the moving sum function.

 

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

 

Thanks

Arun

Contributor

Re: Cumulate Inquiry

Hi Arun,

 

Please see attachment. It includes the previous inquiry.

 

 

Regards,

Super Contributor

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

Contributor

Re: Cumulate Inquiry

HI Arun,

 

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

 

Regards,

Super Contributor

Re: Best Malaysian Curry Past

@mamalams 

 

What's this? Nowhere relevant to the post.

@ArunManickam @nathan_rudman  Looks fishy.

 

Thanks,

Misbah

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