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
Note: Apologies for the attachment I cant seem to paste on the Body a picture that I saved.
Please explore the moving sum function.
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.
Attached mock up isn't clear.Can you please add the same example in the workbook and paste it here
Please see attachment.
What's this? Nowhere relevant to the post.
@ArunManickam @nathan_rudman Looks fishy.
Please see attachment. It includes the previous inquiry.
Understood, will try to change the formula. Is there a reason why it is moving on Mar 20.
Anytime you see a post like the above, please report it to the community team - they will delete the post and ban the account
We don't want this nonsense on our community