This topic contains 2 replies, has 0 voices, and was last updated by JCirocco 6 years, 11 months ago.

  • Author
    Posts
  • #22657 Score: 0

    JCirocco
    • Contributions: 0
    • Level 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.

  • #22658 Score: 0

    torin@aminian.com
    • Contributions: 0
    • Level 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)

  • #22659 Score: 0

    JCirocco
    • Contributions: 0
    • Level 1

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

You must be logged in to reply to this topic.