Setting null running total to zero 3

[Goalie3533]

I want to set all of my running totals that have a null value to display zero on the report but I can't seem to find a way to do that. I could use the "isNull" function if I was using a formula but how could I do this with a running total field?

Thanks in advance.

-Goalie35

 

[Turkbear]

Hi,
One way, I think, would be to be sure the 'set NULL values to Default' is selected under the options menu when the report is designed; that way, the individual values will be 0,not NULL, and the running totals should reflect that.

 

[Davest11]

Goalie,

You could create a formula that returns the value of the running total or a zero when the value of the running total field is null and place the formula on your report in place of the running total.

-Dave

 

[Goalie3533]

Thanks for the help guys.

I ultimately went with TurkBear's idea. I already knew of how to add a formula, as Dave mentioned, and while I knew that method would work, I was hoping Crystal provided a simple 1 click method of resolving this issue, which as TurkBear said, it does.

Thanks for both of your help with this issue though guys.

-Goalie35