formula for getting value from another module

samarapalli
samarapalli
in Modeling

hi all,

Can we get an item value from one module to another module for a particular item . 

Ex:

Module1 | Sales | Rebate

A | 10 | 2

B | 20 | 4

C | 30 | 6

 

In Module2 for the "C2" attribute for the item "AA" needs to get the value form Module1 of "Rebate" column for the item "B". How can achieve it using the formula ?

Module2 | C1 | C2

AA | 100 | ?

 

Thanks,

Satish.

Tagged:

Answers

  • ?.Szyma_ski
    ?.Szyma_ski

    Hi Satish,

     

    I assume your modules are built as specified below
    Module 1
    Line Items: Sales, Rebate
    List Items: A,B,C
    Module 2

    Line Items: C1,C2
    List Items: AA

     

    Then you can simply set formula for C2='m1'.Rebate[SELECT: 'Module 1 List'.B]

     

    Regards,

    Lukasz

     

  • samarapalli
    samarapalli

    Hi Lukasz, thank you for quick response.

     

    I tried your formula but it is throwing an error, please find below attached error.

     

    FORUMULA written as below:

    'Detail - Copy'.Rebate $[SELECT:'Detail - Copy List'.PY Adjustments]

    Err_Ana1.JPG

     

    Thanks,

    Satish.

     

  • ?.Szyma_ski
    ?.Szyma_ski

    Hi Satish,

    Above should work if modules are built as specified in my previous post. Can you confirm my assumtions or I got something mixed up?

     

     

    Regards,

    Lukasz

Categories