take a value from another module

RosarioCaramagno

I have a module named AAA like this:

 

	lower	upper	Payout rate	total invoice	status
tranche 1	0	500	0%	$ 850	0
tranche 2	500	900	2.5%	$ 850	1
tranche 3	900	1200	3.0%	$ 850	0
tranche 4	1200	1500	3.5%	$ 850	0

 

And another module named BBB:

	Quantity	Values $	Rate Applied
product 1	48000	$ 250	?
product 2		$ 210	?
product 3		$ 200	?
product 4		$ 190	?
TOTAL		$ 850

 

I want to put in list item of BBB “Rate Applied” a formula that take the value of “Payout Rate” of module AAA based on the status (only one is <> 0).

 

For example, if status is checked in “tranche 2” the “Payout rate” is 2.5%, so the value of “Rate” in BBB should be 2.5% (in all rows).

 

Which formula do it?

 

Thanks in advance.

 

 

Misbah

@RosarioCaramagno 

 

You will have to find out under what tranche does the product. Once the mapping is done you can use LOOKUP

 

For Example 

 

Product 1 = Tranche 2

Product 2 = Tranche 2

Product 3 = Tranche 1

 

Once it is done create a line item in BBB module (Pref in Sys module) formatted as Tranche list. Use LOOKUP on this list to get the respective payout rates

 

Misbah