2 Replies Latest reply on May 23, 2016 8:59 AM by kschjei

    Search and omit multiple empty container fields


      I have 5 container fields and if all or any 1 of them is empty I want to omit the record. My goal is to just show the records that have documents in all 5 of the containers. I found the below calculation for finding a single empty container field and omit it. Thanks in advance for any help you can give me.


      Show All Records
      Go to Record/Request/Page
      [ First ]

      [ IsEmpty ( TestFile::container ) ]

                Omit Record


               Go to Record/Request/Page [ Next; Exit after last ]

           End If

      End Loop

      Show Omitted Only