Hello Anaplan Community,
I am encountering an issue with one of my development work and would be greatly appreciated your assistance.
There are 2 different modules involved in my model:
1) INP01 Percentage Input by Product (Applies To: P3 List)
2) REP01 Percentage Split by Department (Applies To: Departments List)
The INP01 module allows users to input percentages, which I need to allocate at the department level through defined logic. Currently, we do not have any direct mappings available associated between P3 List & Departments List. However, there is a shared mapping point between these 2 via cost centers. Within the Cost Center system module, we have mappings defined for Product P1 and Departments.
My Objective is to utilize the mappings in the cost center system module to transfer data from INP01 to REP01. The complication arises because a product assigned to multiple departments and Department assigned to multiple products. The desired result is to split the INP01 percentage into REP01 with proportional/Equal distribution.
i would be grateful if anyone could provide guidance or solutions to address this issue. Please refer to the attached screenshots for further assistance.
INP01 Percentage Input by Product:
REP01 Percentage Split by Department:
Cost Center Mappings:
