@JaredDolich , Thank you for the response, Partially understood the solution. I have couple of queries in the solution provided. Que1: How do we calculate the % of the line item i mentioed. Que2: As you can see in the final SMG&A - I need the value of "No product" to be now distributed as per the new % provided into other Products. Hope this helps you get my query. Thanks in advance
... View more
@JaredDolich , Thank you for the response but this hold functionality will only work with Breakback enabled line item. But my line items (X,Y,Z) are not breakback enabled as these are formula based derived values. I tried using this function but was not able to use it. Any other solution ?
... View more
Hi, I have a module with 5 products (A,B,C,D,E). all the products have some values with respect to 3 line items (X,Y,Z). Now i wanted to distribute the value of A in to the remaining products(B,C,D,E). with common percentage. Any idea how can i do it? Example here: A B C D E Before X 100 10 10 10 10 After X 0 35 35 35 35 Similar with Y and Z.
... View more
