[JCirocco Contributions: 0Level 1☆]

We have a scenario where our customer assigns a value to a custom field that they use Externally when displaying Item Availability and Pricing so their competitors cannot map to an actual SKU. I am trying to create a search that will return a result if more than 1 item has the same external part number custom field.

I have not done Summary Criteria in a while but thought it would be simple.

Summary Criteria:

Summary Type=Count

Field=EPN (Custom)

is Greater than 1

Results:

Field=EPN

Summary Type=Group (have also tried Count)

I would think it would return my 2 test items that have the same EPN but I always get No Results Found

Any words of wisdom?
This is a cached copy. Click here to see the original post.

[torin@aminian.com Contributions: 0Level 1☆]

I would change the summary criteria. Change the field you are counting to the item name. In the results group by EPN and count item name. You will need to drill into each EPN name to see the items.

Summary Criteria:

Summary Type=Count

Field= Item Name

is Greater than 1

Results:

Field=EPN (Group)

Field= Item Name (Count)

[JCirocco Contributions: 0Level 1☆]

Darned, knew it would be easy… Thanks! I don't do summary criteria nearly often enough.

[Author]

Posts