Sort report by summary field

[jossmeele]

Does anyone know a way to sort a report by summary fields?

I have a energy efficiency report that lists houses with sum-of-gals fuel consumed and sum-of-gals per sqft. It would be helpful if the report would list the buildings with smallest gals-per-sqft first but FM8 does not allow sort on summary-fields.

Fields are: house_name, delivery_date, gals_of_fuel,

calc-field: gals_sqft=sqft/gals_of_fuel

sum-field: sum of gals_sqft

The sqft comes from a related locations-file that has various house details such as total sqft of the building.

Thanks, Jos.

[John Mark Osborne]

In the Sort dialog, there is an option for "Reorder based on Summary field".

[jossmeele]

:P

Thanks, that was easy!!

It is obviously time to proceed with your VTC intermediate tutorials!! They are very good by the way!

[John Mark Osborne]

Thanks for your kind words.

One time I was teaching a FileMaker class and was showing this technique for parsing a return-separated list into find requests. Someone in the class, who had far less knowledge than me, asked why we didn't just use a different function to make it easier. I started to answer because there was no function like that but when I looked, there it was. Everyone does it, it's just some people don't want to admit it.