Solution:
1. Hit Edit this Search, go to Criteria tab> Summary:
o Summary Type: Sum
o Field : Formula (Numeric)
o Description : case when {location} is null then 0 else 1 end
o Formula (Numeric): greater than
o Value: 1
2. Go to Results tab:
Field Summary Type
Number Group
Name Group
Location Count
3. Hit Preview/Save & Run. Results will show only sales orders with different locations per line item
No comments:
Post a Comment