How to bring values from the same module into different rows
Hi, I'm trying to bring a value entered by the user in the line Item 'New Price for Original Product' which is a value entered in the product B row into the 'Final Price' Line item in row for Product A.
'Original Product' line item is a subsidiary view that brings the original product as text.
The first thing I tried was using a lookup function with 'Original Product' as the mapping but It is not bring the value.
New Price for Original Product [LOOKUP: Original Product]
Any idea on how to achieve this?