SAP Analytics Cloud for planning
source link: https://community.sap.com/t5/technology-q-a/sap-analytics-cloud-for-planning-efficient-way-to-create-a-projection-based/qaq-p/13596669
Go to the source link to view the article. You can view the picture content, updated content and better typesetting reading experience. If the link is broken, please click the button below to view the snapshot at that time.
yesterday
- last edited
yesterday
Hello everyone,
I have a task at hand that involves creating projection based on year-to-date (YTD) actuals.
Allow me to elaborate:
We currently possess the actual data up to March (the last financially closed month).
Our objective is to aggregate the actual values from January to March and divide them by 3 (as there are 3 closed months). Subsequently, this result needs to be propagated to every month in the projection version.
In the subsequent month, April, we will repeat the process by summing up the actuals and dividing them by 4, and so forth.
I have considered aggregating the values by date and then dividing them accordingly, or perhaps using conditional statements to determine the appropriate divisor. However, I am uncertain if this is the most efficient or elegant approach to accomplish the task.
How would you suggest setting up the data action?
I look forward to hearing your thoughts.
Best regards, Ismail
Recommend
About Joyk
Aggregate valuable and interesting links.
Joyk means Joy of geeK