How to read Month module to Quarter Module

shadmani · 2023-07-20T17:05:35+00:00

There was an error rendering this rich post.

shadmani

I am facing a issue to read data from monthly module to quarter module .Here is the scenario -

Model calender doesn't have quarter included.

Source module - Monthly

Target module - Quarter (using time range as model calendar doesn't have quarters )

I created a system module like this to use in sum by condition

In target module - read from source module and sum by Quarter.

Result is zero. Any suggestions?

Thank you in advance .

Accepted answers

All comments

Vinay VaradarajM

Hi @shadmani : One of the ways to achieve this will include building a few intermediate modules using Custom Month list with Anaplan Month and Anaplan Qtr as properties. Shown below:

Data

2. Mapping

3. Data by Custom Month

4. Data by Anaplan Qtr

regards,

vinayvm

StevenBeerthuizen

Depends on sizing, but you can also do this:

fssebastian

Hi,

In relation to getting the sales per quarter.

Target Module : Account (List), Product (List), Quarter (List), Year (List)

Source Module : Account (List), Product (List), Month (Time)

I keep on getting zero value whenever I tried to lookup the sales from the source Module. I have already mapped the Quarter List to the Month Time. What am i missing?

Quick Links

Can you help?

Unanswered questions

Curious Comparison: Forecast Modeling for Unusual Products
I've been experimenting with some forecast modeling techniques in Anaplan recently and decided to test them on a few quirky, offbeat product categories just for fun. One of the categories I played around with was love dolls—yes, you read that right. It actually turned out to be more interesting than expected. Unlike…
OData Rest API for
Hi, Does anyone know how to get an outbound OData Rest API, (OAuth2) to establish a connection between SAP and Anaplan. Thanks Khaled
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.…