Problem aggregating values from timscale day to month

Hi all, I have problems aggregating values from a module dimensioned with day, to a module dimensioned with month. I am doing rent calculations in a module by DAY time scale. When I try to aggregate this to a monthly calc module it does not work. No values are pulled over. It is the last part of the formula below that does not work, where I sum on a line item in the other module that has the format month and time scale DAY (showing the month the day belongs to). For some reason, this sum does not work. Does anyone know the issue? 

CommunityMember117741_1-1664879156543.png

Month line item from the daily rent module;

CommunityMember117741_2-1664879564468.png

 

Kind Regards.

Best Answer

  • @CommunityMember117741 

     

    There is an easier way than using Timesum or Movingsum()....In the module you have above, create a line item with the same sum formula, but remove the sum on days.  In the Time area where it says months, change that to Days, thus creating a subsidiary view.  And as @Misbah stated, keep the summaries on.  This will now properly aggregate to the Months.

     

    Rob

Answers

  • @CommunityMember117741 

     

    SUM doesn't work when the source module is dimensioned by TIME. There are other functions like MOVINGSUM and TIMESUM that we use but in your case I think it is better to turn the summary ON for Time and Keep it NONE for other dimensions. Let time auto aggregate itself.

     

    Hope that helps

    Misbah

    Miz Logix

  • Thank you, it worked. The only drawback is that it inflates the cell count quite drastically. However, in this model that is not a problem.