Hello,
I have a module dimensionalized by years and a "fake" month list (and other dimensions) so I can see line items month to month, year over year. I'm pulling the data from another reporting module that's dimensionalized by time (month) so I'm using a line item to map months to years and using that as a lookup. This all works at the lowest level of my list hierarchy but once I go to the roll-ups the summaries are not calculating correctly and I cannot use the formula setting due to the lookup function. The previous iteration of this module used a select function for every period, but I'm really trying to avoid long hard-coded formulas and keep it dynamic. Any suggestions? (image of module and mapper below)
Solved! Go to Solution.
In situations where I need a lookup but have a ratio or percentage, I bring in the components of the calculation using a lookup into the module and then calculate the ratio or percentage in a separate line item which will allow for the formula summary method.
Bringing each component of the calculations into the current module and then use them as ratio for percentages at higher level should solve your problem as @johndorma suggested