Logic to Solve different companies mapping to SKU as input

Hello All,

I'm trying to solve the below logic but unable to; need your help on the same;

The below module applies to the list SKU. and maps to the company which is applicable based on the boolean.

I have input data sales price by SKU and by month and by all the company

Now, I would like to get the sales price by SKU by month and by company

Example:

SKU Code 123 belongs to the company DFA and FGA. Hence the Sales Price 33681 should be divided between these 2 companies for Apr 20.

SKU Code 789 belongs to only company DFA and sales price 34183 should be allocated only to Dec 20

SKU Code 356 belong to 3 company and sales price 32870 should be allocated to 3 companies (32870/3) for Dec 20.

Output module applies to SKU,Month, Company list

Any thoughts on how to solve this?

Best Regards,

Aish

Accepted answers

manu.mathur

Hi Aish,

please see below steps to solve this, Hope it helps:

All comments

LeonardiT

Hi Aish,

Without any further understanding of the requirement, I assume that the time period input will be some sort of exception per C7 code. Please find the quick mockup that I did. Hopefully it helps with what you're trying to do.

I made a modification to the input per SKU to only show Unit Sales Price and Time Period as you have already made the checkbox selection on SKU Data.

Step 1: Define the check box by c7 code and company then translate that it into a count.

Screenshot 2021-06-27 at 10.03.31 PM.png

Screenshot 2021-06-27 at 10.07.03 PM.png

Step 2: Create another module with c7 code as list and define the price exception (assuming this is the case for all the checkboxes per c7 code).

Screenshot 2021-06-27 at 10.03.21 PM.png

Step 3: Create another module with c7 code, company and time as lists then refer to the sales price exception. For those not defined, I assume that they will just refer to the price defined per c7 code. If this is not the case, you can easily refer to a different module or just stick to the prorate formula:

SKU Input.Unit Sales Price[SUM: SKU Input.Month] / SKU Data.Count[SELECT: Company.All]

Screenshot 2021-06-27 at 10.02.42 PM.png Screenshot 2021-06-27 at 10.03.05 PM.png

Let me know if it works.

Good luck!

Leo

manu.mathur

Hi Aish,

please see below steps to solve this, Hope it helps:

aishabhy05

Awesome!! This Works. Thanks

Quick Links

Can you help?

Unanswered questions

Batch Script
Hello team, I am logging into Anaplan through SSO. I would like to create a batch script to import a file into Anaplan. For the Spoke model, I would like to run an process via a batch script to import data from the Data Hub. Can anyone provide me script for both the condition.
import monthly data with months in columns
is there a way to import data with months in columns (usual excel table view)? I have to transform the data so there are rows to cover each period in the upload data form, but I am wondering if there is a better way to just import the data as is with the months in the columns. please let me know what you think. thank you,
Cloudworks Big Query Integration Fail
Hello, I am receiving an 'Anaplan Upload Failed' Status Description when testing my integration with a Big Query dataset. The integration imports data from BQ to our Anaplan model. No other details given in the error log. I suspect that Cloudworks is not even picking up the file but am not sure what we did wrong on the set…