Sum data from a module with line items to another module with a matching list
Could someone suggest a solution? screenshots attached also.
I have a module (PER01) where I have these line items - the data is by employee (from employee list):
- base salary
- incentive scheme
- other social costs
I have another module (PER02), where I want the above data to fit in with only 1 line item called "input" & dimension accounts list. So in this, the accounts are in a list, not a line item. There are more accounts in the list than the 3 above mentioned ones, which is OK because in actual version, I will need those extra accounts. I noticed that I can write formula and mark the scope to be "all versions but actual", so actual version can still be with data input.
- I added versions dimension to this module - I will only need to get the data into the budget version.
- I added Cost Center dimension to this module
- Employees are not a dimension in this module, but each employee belongs to a cost center so it should be possible to sum the figures.
I have also created an intermediate module (PER03),a matrix, where I connect the line items from the first module (PER01), to the list in the 2nd module (PER02). But I'm kind of stuck here - I'm not sure if this 3rd module is needed, or can I manage without it..
How can i get the data into PER02 by cost base, for budget version from PER01?
Can someone suggest a formula?