How to accmulate record counts ?

[svm]

I got these data that needs to be summarized and at the end do a averaging totals. How do you do this ?

For example I have the following listed :

Accuracy 70

F-Number Base/Alt Rebid# Sq. Feet
F2000 Alt#1 Rebid#1 480.00
F2001 Alt#2 Rebid#2
F2002 Alt#3 Rebid#3 193,107.00
F2003 Alt#1 Rebid#4 106,468.00
F2004 Alt#4 Rebid#1 580.00
--------------------
Totals 300,635.00
Average 75,158.75

Accuracy 71
(Another Details again)

I am doing a subtotal here. My problem is how to come out with a formula to count the records which has a square feet only and divide this value from the total square feet. Appreciate any help you can give. Thanks.

 

[kenhamady]

use:

If SqFt > 0 then 1 else 0

A sum of this will tell you how many records have SqFt, and you can divide by this. Ken Hamady, On-site/Phone Crystal Reports Training/Consulting
Quick Reference Guide to using Crystal in VB

http://www.kenhamady.com/

 

[svm]

Hi.

I am not understanding where to place this code. I did a group definition and define a subtotol for square feet. So, where should I define this statement. Please explain. I am still new in Crystal Reports. Thanks for your patience.

 

[kenhamady]

This should be a new formula field (insert- Field object).
Then you do a sum of this formula.
Finally you create another formula that divides the sum of the dollars by the sum of this formula. Ken Hamady, On-site/Phone Crystal Reports Training/Consulting
Quick Reference Guide to using Crystal in VB

http://www.kenhamady.com/

 

[080898pll]

Create a formula that only counts the records that have square footage >0 and use the count total to divide your total square footage to obtain an accurate average.

Paul

 

[svm]

Guys, thanks for your help ! Appreciate it.