formula for getting value from another module

Highlighted
Occasional Contributor

formula for getting value from another module

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.

3 REPLIES 3
Highlighted
Contributor

Re: formula for getting value from another module

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

 

Highlighted
Occasional Contributor

Re: formula for getting value from another module

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.

 

Highlighted
Contributor

Re: formula for getting value from another module

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