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码123属于公司DFA, 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 Solutions
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
Hi Aish,
please see below steps to solve this, Hope it helps: