I have a module with dimensions Employee and Time (Months). The module contains a list formatted line item "Shop Number" (the shop the employee works in), and number formatted line item "hours worked" (the number of hours that employee worked per month).
I want to bring this data into a second module with dimensions Time (year) and Shop Number. l would effectively like to see how many hours are worked per shop, using the data input into the first module.
Would anyone be able to advise me on the correct formula for this?
On this, and referring to the last point, if you have a fixed relationship between Employee and Shop (using the module as discussed), you can then just use the native Year subtotal in your Employee hours module, if you have the summary options are set to "sum", so the formula would be Employee Hours.Hours[SUM:Employee Details.Shop]
The challenge with the monthly "shop" attribute is what should you use for the year total? Even if we know that the value doesn't change, the Anaplan engine doesn't and what if it did? How do we decide what shop is relevant for the employee when it changes per month. Hence why the structure is prevented.
Using a SUM function for time over time is not possible do to the underlying way that the engine deals with time, but native rollups for month, quarter, year etc will automatically aggregate
So the year totals in a module by month can be referenced in a module by year because the year value exists in the source directly. If you try and map something by month AND try and aggregate, that is when you need the intermedate step(s)