Total quantity Balance

[Lola]

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, 2016 by Lola

[Wim Decorte]

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

[Lola]

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