How do I take MAX value of weeks and use it as my monthly value?

To illustrate

Module A in Model #1 has a weekly time dimension

My goal is to take the highest weekly MTA number of a given month and bring it to a new Model that's dimensioned by months and use the MAX weekly value from Model #1 as my new monthly value in Model #2

MTA's time summary in model #1 is set to Max

When I brought the data from Model #1 to Model 2

I see that MTA now has an imported value of 18.8 in Jan 22 instead of 4.70.

How do I get 4.70 to show up under Jan 22 in Model #2?

Accepted answers

AkhilEmmanual

Ok you can do one thing create a monthly module in same model and you can directly refer from weekly module so u will get correct data in monthly module. This module you can import into monthly module in other model. I hope this will help you.

All comments

AkhilEmmanual

Hi @ashasli you can achieve this just by putting summary as Max in weekly module and directly referring that in monthly module.

weekly module.png

Weekly module blue print.png

monthly module.png

Thank you

ashasli

Thanks @AkhilEmmanual I changed the summary to max in the weekly module and then from the monthly module imported the weekly module. I'm still getting an aggregation of the weeks.

Both of the modules are dimensioned by accounts and SKU#

Please see the attached screenshots.

Blueprint Monthly module.JPG

Blueprint Weekly Module.JPG

Monthly Module.JPG

Weekly Module.JPG

AkhilEmmanual

Are you importing data from weekly module to monthly module?. Because i cannot see any formula in monthly module . In monthly module Just refer the line item in weekly module. I hope this will solve your issue.

ashasli

@AkhilEmmanual Yup! I'm importing it from weekly to monthly.

AkhilEmmanual

You can directly refer it right ? Why you need to import?

ashasli

@AkhilEmmanual I need to import it because they are in two different models.

Hi, @AkhilEmmanual I created a monthly module but because my time setting is in a 13 4-week periods, I find it difficult to map it to months. I did find a workaround. I was able to import the weekly values to a text field in the other model and it worked (see attachments).

Quick Links

Can you help?

Unanswered questions

Introducing Anaplan API Python SDK
Hey everyone, I wanted to share the Anaplan Python SDK with you. It's a Python Library that wraps all Anaplan APIs and makes it easier to interact with Anaplan programmatically. It is mostly designed with Data Integration Scenarios in mind, but it does support all APIs including ALM, SCIM, Audit, and Cloud Works. Please…
Cloudworks Big Query Integration Fail
Hello, I am receiving an 'Anaplan Upload Failed' Status Description when testing my integration with a Big Query dataset. The integration imports data from BQ to our Anaplan model. No other details given in the error log. I suspect that Cloudworks is not even picking up the file but am not sure what we did wrong on the set…
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.…