I have a module named AAA like this:
And another module named BBB:
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.
You will have to find out under what tranche does the product. Once the mapping is done you can use LOOKUP
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
Take a look at this: