How to grab value for chosen selectors to another module?

KacperSzafranski13
KacperSzafranski13
in Modeling

Hello Guys, I need your advice, I have created a Store Cost - Category % module

image.png

and I have a second module PLD08 - Group P&L, I need to get one value from it for selected specific list elements.

image.png

I would like the original value 2 for these specific selectors to be in Value in Store Cost - Category %. At this point he receives in Value the sum for the highest levels of each selector.

image.png
image.png

Tagged:

Best Answers

  • Dikshant
    Dikshant
    Answer ✓

    Store Cost Category % module has only one dimension (Type of Costs). So when it picks the Original Value 2 from PLD08, it will sum up the data for other dimensions. You can't set the selectors in PLD08 Module, and that value will not come in Store Cost Category Module.

    Instead, create a Lookup Module with No Dimension. Add line items for Lookups. These Line item are list format (lists that are used as dimension in PLD08) and use these line items for lookup in Store Cost Category Module while fetching value from PLD08.

  • AjayM
    AjayM
    Answer ✓

    @KacperSzafranski13 -
    In addition to what @Dikshant has advised, the lineitems in lookup module can either be
    > formula driven using FINDITEM on required list item (this is static as you supplement definite value within finditem), OR
    > left without formula so that you can select the required list item (which is more flexible).

    However, in the later case, please remember to select required list items in every new deployed model.

    Cheers!

Categories