I need to know how many locations per item I have on hand, but the list can contain multiple lines for 1 item on 1 location. I was thinking about below, but it doenst work.
If [Subinventory] (string) is HL120LL or HL120UL or HL180 then countd [Locator] (string).
3 answers
Hi @Davey Brankaert
You could try something more like:
COUNTD( IF [Subinventory] IN ('blah','blah','blah') THEN [Locator] END )
Let me know if this helps, or post back with some sample data and a note on what they expected output would be.
Ta, Steve
