Running Total won't display 0 1

[ciscowiz]

I am using CR9--I created a running total field to perform a count on a string field. On the "Evaluate" section of the running total I am using a formula where the field equals a specific string. It counts the instances of this string. Works fine unless there are no records to count. It displays nothing but I need it to display a zero value because my other function is depending on all numbers. Thanks to anyone who can help.

 

[lbass]

When referencing the running total in your formula, you could instead use:

(
if isnull({#myrunningtotal}) then 0 else
{#myrunningtotal}
) //etc.

-LB

 

[ciscowiz]

Thanks again LB!