Summary function incorrectly ignores rows with a null value

[Morgan]

So I have two columns of numerical data displayed in a data band, like so:

Budget Actual
5000
20000 20000
10000 10000

with the first 'Actual' value being null. When I do a simple sum, it works correctly, giving me the sums:

Budget Actual
35000 30000

But then I want a percent of budget as well; I've been doing this like:
{data.ACTUAL / data.BUDGET}

which works fine on data rows, but on the summary in the footer, I have to do this:

{Div(Sum(DataBand1,data.ACTUAL), Sum(DataBand1,data.BUDGET))}

and the result looks like:
Budget Actual %
5000
20000 20000 100%
10000 10000 100%
Totals:
35000 30000 100%

which is the wrong percentage. When I set 'Convert Nulls' property to True, it becomes this:

Budget Actual %
5000 0 0%
20000 20000 100%
10000 10000 100%
Totals:
35000 30000 85.71%

which is the correct percentage, but then I have extra '0' values lingering around. Is there a way to both get the correct percentage and not display the '0' values?

(Edit: It is possible that the 'Actual' value is '0' instead of Null; in such cases I would like to display '0' and not blank)

[Alex K.]

Hello,

Please send us a sample report with test data which reproduce the issue for analysis.

Thank you.