Lookup considering the Month

Luis98
Luis98
in Modeling

Hello, 

I have a Price List named "Raw Materials Price", and I need to pull from "Component Cost Increase" module the % increase by Component, Plant and Period (Jan 2021), hoy can I consider the period in the lookup formula?

Raw Material Price List:

Luis98_0-1630427226750.png

Formula:

Luis98_1-1630427305289.png

Component Cost Increase Module:

Luis98_2-1630427543685.png

 

 

Thanks, regards

Tagged:

Comments

  • rob_marshall
    rob_marshall

    @Luis98 

     

    It is not best practice, for this reason as well as others, to put transactional data as properties of a list.  Instead, create a "transactional" module using this list as well as Time with a line item of Price and import the data into that.  This will help with performance of the model as well as getting the data to other modules.  While you are at it, load the UOM attribute to a SYS module and you can, using formulas, determine the Plant and Component based off the member.

     

    For more information on this, take a look at this article:

    https://community.anaplan.com/t5/Best-Practices/Data-Hubs-Purpose-and-Peak-Performance/ta-p/48866

     

    2021-08-31_13-35-43.png

     

    Hope this helps,

     

    Rob

Categories