Hello All,

 

I want to find the total quantity remaining of my materials excluding my materials with status (Used ; Rejected ; and Expired).

 

I tried using case function

 

Case (  Material Remarks = "Expired" ; 0 ;

            Material Remarks = "Rejected"  ; 0 ;

            Material Remarks = "Used" ; 0 ;

            Material Quantity Received - Material Quantity Used )

 but its not working.

 

Please find attached file that Im working.

 

Thank you so much.

 

LoLa

Materials.zip

Edited February 28, 201610 yr by Lola

"material remarks" is empty for all records.  But "status" is not...

Hi Wim,

Thanks for the reply. I tried putting values on my "Material Remarks" but still not giving me my "Material Quantity Total Balance" is not giving me my desired result.

Thanks