Skip to Content

Displaying 0 for a running total when the condition wasn't met

I have a running total on my report that uses a formula to decide whether to evaluate which fields to total. In some cases, the condition is never met within the group. I have the running total displaying in a field. However Crystal won't display 0 in the field, it just hides the field. How do I get it to display 0?

Also, I need this to use this running total in a formula. In my formula I have:

 If {#runningTotal} > 0 then "do a barrel roll :D"

But when I try to display this formula that has #runningTotal in it, it just shows a blank field. It works fine if the condition is met and has a number to use.

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • Best Answer
    Aug 07, 2018 at 06:19 PM

    Thank you! That got me there. I didn't think to just check if the var was null.

    Instead of

    If {#runningTotal} > 0

    I can use

    If ISNULL({#runningTotal})
    

    Add comment
    10|10000 characters needed characters exceeded

  • Aug 07, 2018 at 06:10 PM

    The problem is that the result of the running total that you're dealing with is actually null. So, there are a couple of things you can do.

    1. Automatically account for nulls by going to File >> Options >> Reporting tab and checking both "Convert Other NULL values to Default" and "Convert Database Null values to Default". This is the easiest way to handle the issue.

    2. Manually handle the null values. This would mean using a formula in the running total instead of the field:

    {@Value for Running Total}

    if <condition from running total> then {MyTable.MyField} else 0

    You can then take the condition off the running total, since it's in the formula here. The result will be 0 if the condition is not met.

    -Dell

    Add comment
    10|10000 characters needed characters exceeded