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?
Best Answer
-
Obviously, it depends on other values, such as
- in your picture, is Product in the Rows?
- will Product B on have A as the Original Product or will others have A as well? If only one Product (row axis) will a unique Original product, then the below will work…if not, say Product C has A as the Original Product, then this fails.
With that said, check this out and see if it will work for you. Basically, use a SUM instead of the lookup.
1
Answers
-
Thanks, Rob. Your assumptions were correct; the product is listed in the rows, and it's not possible to repeat any product in the 'Original Product' column. Therefore, using the SUM function solved my issue. Much appreciated.
0