-
October 13th, 2020, 07:09 AM
#1
Creating formula that checks multiple lines in a single group based on Primary key
I have grouped data by a primary key in this case a dispatch number. In that dispatch there are product types ie, parts/machines etc. However I am attempting to filter out the dispatches that have a mixture of types that I can define in that part type category.
For example, a dispatch that has both “machine” and then another line with “parts” in it. I would want to be identified. Where as if all of the dispatches where the lines were exclusively “parts” I would want them separated also.
I have attempted using the field that counts the lines in a dispatch in a loop but that fails in the formula editor. I was wondering if you could think of a simpler solution that I may be overlooking?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|