I am making a report of the payments received from patients by all sources, Primary ins, secondary in, Deductible, copay and Patient pymt. I made a aggregate query and made my report from there.

I want to be able to see only the pending payments. My final balance needs to show Null values or Not O. I cannot put this condition in my query. How do i put it in my report. I am adding images but have removed all HIPPA Protected info. Please guide me.