I have a scenario where i have to calculate the commission based on multi level payout grid. Input : End user will be able to define payout grid at any level of dimension by month on month , based on that particular month payout structure. Ex : April month Applicability of Payout at 2 level of list i.e A,B. Assuming Each List have two children - A -> A1,A2 , B -> B1,B2. April Month Payout grid : Slabs A1,B1 A1,B2 A2,B1 A2,B2 0-50K 10.00% 10.00% 10.00% 10.00% 50K -1 Lakhs 15.00% 15.00% 15.00% 15.00% Data and Calculation A B C Amount payout % Invoice 1 A1 B2 C1 40000 10% invoice 2 A1 B1 C1 60000 15% For may month , C list can be added in payout grid , so accordingly need to define payout grid. how can we resolve this problem in anaplan , to provide multilevel dimensional module to capture the payout % by month on month.
... View more
