2 Replies Latest reply on Jul 25, 2013 12:21 PM by thong127

    Summary

    thong127

      Title

      Summary

      Post

           Hi All,

           I Have a the following fields

      1. Total Quantity Balance which is a summary field, (Total of Material Balance(running with restart),when sorted by classes::Material Balance

      2. Status which is a dropdown (Expired, Reject, Quarantined)

      3.Material Balance  which is a calculation field If ( Status = "Expired" ; 0 ; Quantity Received - Quantity Used )

           Now, I want to add Reject, and Quarantined to Material Balance so that all materials having a Status of Expired, Reject and Quarantine will not included to the Total Quantity Balance.

           Please help me.

            

           Thank you.

           thong

            

        • 1. Re: Summary
          philmodjunk

               Option 1:

               If ( Status = "Expired" or Status = "Reject" Or Status = "Quarantine" ; 0 ; Quantity Received - Quantity Used )

               Option 2:

               If ( PatternCount ( "ExpiredRejectQuarantine" ) ; 0 ; Quantity Received - Quantity Used )

               Option 3:

               Case ( Status = "Expired" ; 0 ;
                            Status = "Reject"  ; 0 ;
                            Status = "Quarantine" ; 0 ;
                            Quantity Received - Quantity Used )

          • 2. Re: Summary
            thong127

                 Thanks Phil