GetSummary() problem

[s yeh]

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, 2008 by Guest

[comment]

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

[s yeh]

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

Edited October 28, 2008 by Guest

[comment]

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.

[mr_vodka]

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

[s yeh]

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.

[mr_vodka]

Go under MY Profile --> FileMaker Questions

[comment]

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.

[s yeh]

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.

[mr_vodka]

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