How to read Month module to Quarter Module

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 .


  • 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:

    1. Data

    2. Mapping

    3. Data by Custom Month

    4. Data by Anaplan Qtr



  • Depends on sizing, but you can also do this: