I'm currently struggling with the calculation of the monthly commissions FC.
Issue:
Quarterly commission Forecast:
Unable to get quarter values by sales rep. How to bring down Annual sales target into Quarterly?
Kindly help me on this.
I would recommend checking out the Level 3 forums for requirement clarifications.
L3 is a proficiency exam as such you should leverage past learnings and resources in the Anaplan Community to complete the course independently. When I found myself getting stuck, I would review preceding lessons to ensure I didn't miss any critical steps.
Hi @Dev_08 Were you able to sort out the monthly/quarterly forecast? I am stuck at the same step.
Just like we're asked to create Quarter apportionment for monthly commission forecast, I created an year apportionment to calculate quarterly Forecast. I multiplied the year apportionment to Annual Sales Target value we have.
However my values are not as expected, as can be seen below,
Looking for your views on this.
Regards
You can start by dividing your annual goal evenly across 4 quarters if sales don't fluctuate much seasonally. Adjust your quarterly goal by a percentage based on sales data from previous years. Continue dividing evenly across 3 months in the quarter or customize based on specific monthly data.
Hello folks, Does anyone know how to work around the Polaris limitation of using the Formula or Ratio summary method alongside the Closing Balance within the same line item? I have a Business Unit list where the total (All BUs) must display the Corporate (1 of 20 leaf items under All BUs total) number of Unique Customers.…
Hello community, I have an issue with anaplan report (functionality). The issue I have is within couple of slides. The data in that report is scrolling into a new page. There is a hierarchy in the rows and line items and time in the columns. My problem is, the hierarchy is getting broken in the second page. One of the node…
I want to create an S3 connection that will have monthly data stored in individual csv files that is connected to ADO. Around month end, data will be uploaded multiple times, replacing existing csvs. When this happens I want to replace the existing data for that month with the new file. I don't want to have to create a…
