2 Replies Latest reply on May 17, 2012 4:48 AM by user17322

# Report Footer Avg

### Title

Report Footer Avg & Sum

### Post

I'm new to FM12 and not a programmer. I have created a report that I'm trying to create a caclulated field which will give me the average price per square foot for a list of real estate transactions. I have the amount of the sale and the size of each (NRA).

Currently the calculation looks like the screen shot below. Please let me know what I'm doing wrong? Thanks.

• ###### 1. Re: Report Footer Avg & Sum

You might want to look up Sum in Filemaker help.

Sum expects a list of fields in one of three formats:

Sum ( Field1 ; field2 ; field3 ...)

Sum ( RepeatingFIeld )  // this sums all the repetitions of a repeating field

Sum ( RelatedTable::Field ) // this sums Field from all the related records

What you have is the equivalent of Sum ( 5 ) and the sum of 5 is 5.

If you want the sum of all the records in your found set, do it this way:

Define a summaryfield, sTotalSalesPrice as the total of Sales Price.

Define a summaryfield, sTotalPropertyNRA as the total of Poperty NRA

Then define your calculation field as sTotalSalesPrice / sTotalPropertyNRA

• ###### 2. Re: Report Footer Avg & Sum

Thanks Phil,

I played with it for about an hour and came to your exact conclusion. I was not familiar with Summary Fields and now I've learned.

Steve