How to build a logic in Anaplan to solve the attached problem

Need suggestions on how to build the logic in Anaplan to solve the problem in the attached file.

Negative CF is to be adjusted first from the previous weeks and then if balance amount is there then we have to look into the future weeks for the adjustments.

For a specific week, you can go back by "m" weeks for adjusting the negative CF and then go forward by "n" weeks for adjusting the negative value.

5 weeks time period is just for an example and it can be 52 weeks or more and irrespective of current week all the future weeks to be adjusted

FIT_Logic_76572.xlsx

Accepted answers

All comments

Misbah

@CommunityMember111275

Can you clarify:

Why only Week 5 needs to display data, why not all the previous weeks?

Is Week 5 your current period and what should be the logic for future weeks?

Here is what I was doing. This is not your desired outcome but you can take a cue from here. If not I will develop it further once I receive clarifications from you

CommunityMember111275

Week 5 is not the current week.

5 weeks are just for an example.It is a continuous data. It may be for 52 weeks or more and irrespective of current weeks, CF of all the future weeks to be adjusted.

Quick Links

Can you help?

Unanswered questions

Request for Workflow Design: End-User Report Finalization & Stakeholder Notification with Version Co
Hi everyone, I'm looking to design a workflow and would appreciate your input or guidance on how to set this up effectively in Anaplan. So, the goal is: Once end users complete their data input, they should be able to trigger a process that: Notifies stakeholders via email with a link to a report. The report includes: A…
OAUTH 2.0 vs Google Sheets Extension
Hi, My org is looking to explore leveraging Google Apps script to extract data out of Anaplan and update already built templates in Google Sheets. We use the Anaplan Extension currently but find it crashes often with the amount of tabs, data, etc. Has anyone used both Anaplan OAUTH 2.0 API and Goolge Apps Script to write…
Exports with anaplan using informatica connector
I'm trying to execute an Action to export data with the use of a Mapping in Informatica. But it gives us null rows .If we export directly from Anaplan , the export file has all the rows filled. Both exports have same number of rows but in the informatica export the values appear as blank. This issue is with only some…