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.