I want a saved search for work order issues and completions, that put for an item, all lots from the inventory detail in a single field. When I used max(NS_CONCAT) function,it repeats the lot. How do I structure the formula so that I get only one instance of each lot?
result of NS_CONCAT: B1114221440,B1114221440,B1114221440,B1114221440,B1017221080
I want only B1114221440, B1017221080