Contributor

## 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

1 ACCEPTED SOLUTION

Accepted Solutions
Occasional Contributor

Hi Aish,

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

3 REPLIES 3
Contributor

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.

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).

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]

Let me know if it works.

Good luck!

Leo

Occasional Contributor

Hi Aish,

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

Contributor
Awesome!! This Works. Thanks