Summary setting for module dimensionalized by years and fake months list

moriahreyes
moriahreyes
in Modeling

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)

moriahreyes_0-1586883952620.png

moriahreyes_1-1586884077199.png

 

 

Tagged:

Best Answer

  • johndorma
    johndorma
    Answer ✓

    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.

Answers

  • Misbah
    Misbah

    @moriahreyes 

     

    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

     

     

Categories