How to get $0 when no payments

[Parvie]

Hi all..

My report is based on a query and some fields of this query are based on other queries (like sum of all payments etc.). my problem is that when there is no payment, I want to see $0 under payment and Balance (calculated field) according to the payment. Everything is fine when there is payment amount, it calculates balances and all, but when a project does not have a payment it gives me blank record for payment as well as balance....Please help....thanks

 

[Newman]

Use NZ(...,0)

 

[Parvie]

It worked...Thanks a million!