Can we get an item value from one module to another module for a particular item .
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 | ?
I assume your modules are built as specified belowModule 1Line Items: Sales, RebateList Items: A,B,CModule 2
Line Items: C1,C2List Items: AA
Then you can simply set formula for C2='m1'.Rebate[SELECT: 'Module 1 List'.B]
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]
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?