Running Total returning Blank

[kpiljava]

Hi i am running a total (SUM) based on certain criteria.If no records are there to get totalled then the field is not shown on the screen.Instead of that number 0 should be returned

 

[dgillz]

Create a formula with your condition:
if <<Condition>> then {FieldToConditionallySum} else 0

If you are resetting on change of group, you can do a simple sum on the new formula field, no running totals required.

If you still need a running total field, change your field to evaluate to the new formula and you should be OK.

Software Sales, Training and Support for Macola, Crystal Reports and Goldmine
dgilsdorf@mchsi.com

 

[kenhamady]

I am not sure that technique will work when there are no records. Is this a running subtotal or a running grand total? Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guide to using Crystal in VB

http://www.kenhamady.com/

tek@kenhamady.com