Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How do I display those records that have more than one occurrence (same item) with the status of 0.

There are 4 fields in my object:

     Item Number

     Status   (0, 1, Null)

     Item Discription

     Vendor

I want to disply only those records that have more than one occurrence (same item number) with the Status of 0.   Do you know of an easy way to do that? 

1 Reply
Not applicable
Author

you need to create a new field with an "IF" condition, this new field will contain just what you placed in your "IF" condition.

Greetings!!