Sum with no data

[octatyan]

Hi all, here's my problem...

I have a query that adds up all budget increases for a budget. But the problem is there are currently no increases made yet. So it's like the data is all null. How do I make it so this null value is equal to zero?

Any help is greatly appreciated.

* I tried to make the explanation short, but if it's unclear I can rephrase.

 

[llkhoutx]

Use the NZ function on your sum.