Monthly ending balance of a module with a weekly time scale bring to another module with monthly sca

appreciate if someone can check and give some directions. Thank you.

I wrote..

IF NOT 'SYS01 Time Settings By Week'.First Week of Timescale? THEN PREVIOUS('INV01 Inventory Ordering'.Ending Inventory) ELSE 'DAT01 Beginning Inventory'.Beginning Inventory

I need to extract only monthly endling inventory balance to another module...

source module is below: time scale weekly, summary method is set to - sum;time-ending balance, dimension is P3 SKU

Target module is below : time scale monthly, G3 Location, dimension is distribution canter sub set

Comments

andre.lie

@augustus.perera

Since the difference between your source and target modules is the distribution center list, you can use SUM function based on the system module that has the same list as the source module and provides look up for the distribution center

augustus.perera

Thank you Andre.

Quick Links

Recent release news

May 2025 platform releases and what’s next
Check out the latest Anaplan feature updates and enhancements in our May 2025 official release notes. The information below offers supplemental information to that post. Integrations and extensibility Preview dataset when mapping to model or selecting for transformation view in ADO When selecting a dataset to map to a…
April 2025 platform releases and what’s next
Check out the latest Anaplan feature updates and enhancements in our April 2025 official release notes. The information below offers supplemental information to that post. UX New UX for Models section in Administration The Models section in Administration has been redesigned with a more intuitive interface. Tenant…