Hi ,
I have 2 lists, List 1 and list 2.
I have a module with line items List 1 code, List 2 code and type and applies to as List1..
The values are as below. I have another module with applies to as list 2. I need to pull in items of Type A into line item 1 and Type B into line item 2 based on the List 2 code. Please can you help me on the formula.
Regards,
Rajasekhar
Thank you but please not the ABC, XYZ etc are all in text format. Hence the SUM function would not work.
I was able to create line items in Module 1 and bring Type A and Type B items but unable to apply the SUM as all of these are in txt format and not list format.
Please can you provide some work around.
Instead of TextList, try using FirstNonBlank or LastNonBlank. TextList is very poor for performance reasons.