running total

[Anoli]

Also I tried a different approach:
I created a field that is 1 if the record detail is the first one (or the only one)in an invoice and zero otherwise. I multiply this field with the receipts amount and I get a new formula field that is equal to the receipt amount for every first detail in the invoice and zero otherwise. Now I would simply want to to a sum for the whole report. The proble is that the sum button it is not available (it is greyed out). The field is definitely numeric.What is the problem in this case?
Thank you for your help.

 

[africanernie]

Hi,

I assume you are working in crystal reports. There is a feature built in to the program to count record and give total. try searching the help index for "SUM" or "COUNT".

Regards

e

 

[kenhamady]

You can't sum a running total, but you don't need to. You can create a running total that only includes first record of each group. What version of CR are you using? Ken Hamady, On-site/Phone Crystal Reports Training/Consulting
Quick Reference Guide to using Crystal in VB

http://www.kenhamady.com/

 

[Anoli]

Hi there:
Thank you for your replies. I was using Crystal 6.0 but uponmoving to ver 7 I was able to use the running totals formulas adding only the first record in the group, the way kenhamady suggested. Thanks for your help.