why is my running total returning nulls?

[yehong]

CR8.5.
I have a running total on an amount field that sums the amounts by group.
I have already taken account of Null value in the report view as NVL(Field.Value,0)as Filed. I expect that when there is no value in the Field, the running total still should show me a 0, but it is not showing anything, and I have to create another formula like:
IF IsNull(#Total)Then 0 Else #Total
to show a zero on my report. I have about 20 running totals and I don't like to create 20 formulae to account for Null value if there is a way to do it in running total itself. Thanks.

 

[synapsevampire]

Did you try placing in the Evaluate->Use a Formula:

not(isnull({table.field}))

I understand your frustration, but you aren't stating the field type, what you're doing in the Running Total (is it on a group and what type of aggregate function?).

Perhaps you're expecting a value for groups that don't exist?

You're handling the null in the View, so I suspect that it isn't this field, your assumption that it's still null makes no sense to me, you've already converted it.

-k