How do I reference an empty running total?

[Former Member]

Crystal Reports

I have a running total that I am referencing in a format condition for another cell.

Sometimes the running total will not have any eligible records, and will be blank.

It is when RunningTotal1 is blank that I want a particular color applied to my other text.

I tried with a <1 condition, an =0 condition, I get a syntax error if I try to us = ""

What is the correct way to reference this RunningTotal1 condition/value?

The help section indicates that null number values are 0, but that does not work in this case.

To duplicate, create a running total, that is reset on change of a group. You must have some groups that do not have any eligible records, others that have records.

Then, color condition, or any other condition a different value based on the value of the running total. How do you successfully identify the running total value for your groups that have no records?

[Former Member · Accepted solution]

Answer is:

Go to File - Report Options

Check the box Convert Other NULL Values to Default

This forces a zero to the running totals with no records.

You can then run reference formulas tying to the running total that reference If runningtotalname = 0