formula for getting value from another module

samarapalli

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.

?.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