I am having difficulty figuring out how to use the GetSummary function and was wondering if someone could help me out.

I am creating a table that displays therapists and their treatment time(in minutes) of patients. The output looks like this using a 'summary field' for total time-min when sorted by therapist.

Therapist 1 Total minutes 160

patient1 40

patient2 40

patient3 40

patient4 40

Therapist 2 Total minutes 240

patient1 60

patient2 60

patient3 60

patient4 60

I would like to add a field that converts the field total time-min to hours and have tried the creating a calculation using the GetSummary()function (using total time-min and therapist as the break field) but it comes up blank.

This is how I want it to look:

Therapist 1 Total minutes 160 (2:40)

patient1 40

patient2 40

patient3 40

patient4 40

Therapist 2 Total minutes 240 (4:00)

patient1 60

patient2 60

patient3 60

patient4 60

Can someone please give me the sample syntax of creating a field total time-hrs. Much appreciated!

Edited October 28, 200817 yr by Guest

Is your breakfield in the same table, or is it a related field?

They are in the same table. I should clarify this table is ODBC from SQL Server if that makes any difference.

Edited October 28, 200817 yr by Guest

It might - I'm afraid I am not equipped to test this. In a local table, an unstored calculation field (result is Time) =

GetSummary ( sTotalMinutes ; Therapist ) * 60

should produce the result you want, provided that records are sorted by Therapist, and that Therapist is in the same table.

P.S. Please update your profile - this question is obviously NOT about version 5.

Although a subsummary report can be done with ESS data, I am not sure if it will work with GetSummary.

Thanks for the quick responses. I tried the supplied calculation and it didn't work. Any creative ideas on how to capture the value of the summary field data from an ODBC source.

I am going on the assumption that it isn't working b/c ESS but will have to try with local values to see if that is true.

BTW, I am using FM 9 Advanced but it isn't changing in the forum.

Go under MY Profile --> FileMaker Questions

It *might* be possible to do the calculation in a local table of Therapists, and bring the result back by placing a related field in the sub-summary part. But you would need to filter the summarizing relationship by the same criteria as the find in the ESS table.

Thank you for all your suggestions. My conclusion is that I don't think the GetSummary()function works with summary field in an ESS data table. Please let me know if someone knows otherwise.

My workaround was that I created script to import the found set into a new table and run the subsummary report from there. It works for my needs so far.

Why dont you just create a second calc and a summary field for your hours field. A subsummary report will work with ESS.