Hi, I am in need of some ideas, on how to solve a problem I am facing. I have these 3 modules (picture below). The module OC Expected Renewals contains numbers. OC Expected Renewals already pulls in data from from the module 4f ACV Calculation, but, now I also need it to pull in target values from 5f Official Customer ACV into a new line item in the module (number formatted), call it target value. Here in lies my current issue. OC Expected Renewals module has a customer list in rows and hand and another list in pages (see arrow), which we can call list A. List A contains 3 items; Blades, Products and Support. These three items are available in three different line items in the 5f Officials Customer ACV module. What I need to do is to pull the target figures from 5f Officials Customer ACV module into the OC Expected Renewals module with regards to each customer and which item is selected in pages from list A. The OC Expected Renewals module applies to a different list than the 5f Officials Customer ACV module, but, the the 5f Officials Customer ACV module has a line item called customer which has the same list format as the module I will pull the data into. What I would want to do is a formula similar to eg. If 'List A'.Blades then 5f Official Customer ACV.Target value[lookup:5f Official Customer ACV.Customer] else blank. The problem is that the line item target value adheres to the 5f module's list which is different from the line item customer (which has the same list as the target module, OC Expected Renewals. In conclusion, I am trying to pull in a value from three different line items in a source module, and, which line item the formula pulls information from, to display, is dependent on which customer and which items in list A. But, the source and target line items have different formats and lists. Kind regards,
... View more