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?

Month line item from the daily rent module;

Kind Regards.

Accepted answers

rob_marshall

@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

All comments

Misbah

@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

rob_marshall

@CommunityMember117741

Rob

CommunityMember117741

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.

Quick Links

Can you help?

Unanswered questions

Predefaulting A Feild in ANAPLAN
Hello Anaplan Community, I have a special requirement from a customer and would appreciate your input. Let me explain the situation: We have a hierarchy with three levels: Level 1, Level 2, and Level 3. Screen 1: Creation of Level 1 Items On this screen, the user selects a team. Based on their selection, an action runs to…
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…
CERTIFICATION BADGES - ANNOUNCEMENT
Anaplan Champions! The Community team just posted this announcement that certification badges may not be showing up on your profile probably until next year. Rest assured, you will get credit once you complete and pass the exams. https://community.anaplan.com/t5/Blog/Badges-Back-Soon/ba-p/123385