I have a list with 5000 items. But If I want to add this list as a dimension in a module, the module is too big. Now, I don't need all 5000 items so I created a second list that has the 50 items I need. Then I can make a module CAL06 with all the dimensions I need. It's not too big anymore. So far so good
In this module CAL06 I make a line item that searches another line item of a module IMP00 in tabular form where all the columns contain data that is linked to lists in anaplan. So far so good.
I put a formula in this line item where I make a sum of all the dimensions in that module CAL06 that match the columns of that other module IMP00:
'IMP00 Actuals Unit 4 Import'.Montant K€ BeGaap[SUM: 'IMP00 Actuals Unit 4 Import'.'Product SPC Level 3', SUM: 'IMP00 Actuals Unit 4 Import'.Month period, SUM: 'IMP00 Actuals Unit 4 Import'.'CoA Non-Life', SUM: 'IMP00 Actuals Unit 4 Import'.LoB Nomad intermediary, sum: 'IMP00 Actuals Unit 4 Import'.Compte,sum: 'IMP00 Actuals Unit 4 Import'.Occurrence Final,sum: 'IMP00 Actuals Unit 4 Import'.'Channel L1' ] |
|---|
Now, in this IMP00 module, there is a column with the general account code wich is linked to the list general account#(5000 items) and which is called "Compte". I made a shorter list like I described above (50 items) which is called general account#PF but which has the same code as the bigger list
In my formula above the sum for "Compte" does not work because Anaplan cannot sum the "compte" column with the dimension "general account#PF" in my CAL06 module. Why? The codes are the same???
What can I do to resolve this?
