Formulas - dimensions month vs years & collect

CommunityMember113484
CommunityMember113484
in Modeling

Hi,

I have a module that shows line items in years and uses the collect() function.

I now need this in months, so have made a copy of this module, changed dimensions to months and there's currently no figures showing. How do I fix this?

Thanks in advance

 

Tagged:

Answers

  • ChrisAHeathcote
    ChrisAHeathcote

    @CommunityMember113484 

    Use YEARVALUE() function to pull the data from the module using COLLECT().

    This will allocate the year value to each corresponding month.

    However, it will not phase the year value across months in the year as it will simply assign the year value to each month.

    To do this you need to decide how you wish to phase the year value down. 

  • CommunityMember113484
    CommunityMember113484
    Thanks Chris. I think I'm still struggling with the collect() function.
    In the original module (year), the formula states IF X THEN if Y then Collect() ELSE 0. When I drill down to this, it takes me to a new module where the figures are being collected from.

    In the new monthly module, the formula is still the same, but when I drill down, it doesn't take me to that original module? I'm left with just 0?
  • ChrisAHeathcote
    ChrisAHeathcote

    @CommunityMember113484 

    The monthly module should simply reference the module holding the yearly data.

    No IF THEN ELSE just YEARVALUE()

     

  • alexpavel
    alexpavel

    @CommunityMember113484  My impression is that the current original data from the current original module (the module before the COLLECT() ... they are already at Year level. 

     

    If this is the case, then, this is the issue: Target module is at month level and Source module is at Year level. 

    I think you should trace back in your model what is the module where data are at the month level. 

     

    Hope it helps

    Alex

Categories