Formula to take 1 unit data to another

Hi Anaplan,

I am trying to create a model to summarize the volume from the region and paste back into manufacturing unit, not sure what formula should work in this situation.

For example, Australia (Reporting Unit) and New Zealand (Reporting Unit) purchase plastic cup from Hong Kong (Manufacturing Unit) by 300 cases, I want to put this 300 cases back into Hong Kong (Reporting Unit). How can I create the formula to pick up all the demand 300 cases under Hong Kong (Reporting Unit) ??

Thanks,

Kiwi

Accepted answers

JaredDolich

kiwi.chow@huhtamaki.com ,

Here's an example using @DavidSmith and @Misbah

You will want to set up system modules first for the manufacturing units and reporting units.

See the DISCO method for more details.

Here is the system module for manufacturing. Super simple.

You will need this to do the Sum on demand.

System Module.png

Then we enter demand as you suggest up above.

Next, you add a formula in your supply module that sums the demand by manufacturing plant.

Demand = Demand[SUM: List formatted line item for manufacturing units]

And the result:

All comments

DavidSmith

kiwi.chow@huhtamaki.com

SUM and LOOKUP are what you are going to need.

https://help.anaplan.com/anapedia/Content/Calculation_Functions/All/SUM.html

https://help.anaplan.com/anapedia/Content/Calculation_Functions/All/LOOKUP.html

If you take the new Level 1 training, we do cover this in a lot of detail too

Also, take a look at the following and also the attached slide deck I've created to help with the understanding

https://community.anaplan.com/t5/Anaplan-Platform-Discussions/Converting-data-between-line-items-with-different-lists/m-p/37976

https://community.anaplan.com/t5/Anaplan-Platform-Discussions/Lookup-Sum-and-Textlist-Cheat-Sheet/td-p/53085

https://community.anaplan.com/t5/Anaplan-Platform-Discussions/Dimension-Mismatch/m-p/53248

If you can master these techniques (with System modules), you'll build efficient and flexible Anaplan models

I hope that helps

David

SUM_and_LOOKUP_54682.pptx

Misbah

kiwi.chow@huhtamaki.com

Is there any hierarchy in place? Connection between Region & manufacturing unit or reporting unit?

Thanks,

Misbah

JaredDolich

kiwi.chow@huhtamaki.com ,

Here's an example using @DavidSmith and @Misbah

You will want to set up system modules first for the manufacturing units and reporting units.

See the DISCO method for more details.

Here is the system module for manufacturing. Super simple.

You will need this to do the Sum on demand.

System Module.png

Then we enter demand as you suggest up above.

Next, you add a formula in your supply module that sums the demand by manufacturing plant.

Demand = Demand[SUM: List formatted line item for manufacturing units]

And the result:

kiwi.chow@huhtamaki.com

Thank you, this is much more clear to my mind 🙂

Quick Links

Can you help?

Unanswered questions

How have you from-scratch built lot-level, geo-based Inventory Consumption?
We’re working on modeling inventory consumption at the lot level, accounting for shelf life considerations, since we need visibility into which lots may not consume—both for risk reporting and E&O analysis. Each item may have customers with different shelf life requirements. For example, item A may need 270 days for some…
How to bring Row data into Columns?
Hi, Can you help me, how can we get row data into columns using Unique ID? Per attached below first snapshot, I want to bring rountingOrder 4, RecipientName, Sent and Completed dates in 1 row as show in sanpshot 2. Do I need to create Hierarchy list and Map?
How to Design Simulation Planning in Anaplan with Multi-Level User Input and Step-by-Step Logging?
Hi Anaplan Community, I'm working on a simulation planning model where users need the flexibility to input pricing adjustments at any level of the product hierarchy, and I’d love your guidance on best practices. 📌 Scenario Overview: We have a 4-level product hierarchy: Brand Category Sub Category SKU (lowest level) The…