I know this can be done with FM, but I can remember how.

Can anyone tell me how too do statistical analysis with FM8. For instance,
an analysis of a telephone log: Average time of calls, where the city called
was Los Angeles AND where the caller was Jane.

I tried the GetSummary function in a summary field, but that didn't work. I
also tried the Case and If functions; those didn't work either.

Any help is appreciated, and to all, have a wonderful year.

Thanks

You create a field 'Sort_token' (calc) = Case( Town = "Los Angeles" and Name
= "Jane"; 1; " ")
You then either by hand or via a script, 'find' the records where Sort_Token
= 1.
You create a field 'Average_time' (summary) made as 'average' of 'time'.
Then you make a layout with at least the 'time' field in the body part and
another part 'subsummary after sort' - choose the sort on 'Sort_token' - in
which you put the 'Average_time' field.
Then you sort by 'Sort_token'. You go to 'Preview mode.
You may also have another layout where you withdraw the body and thus get
only the sub-summary part.
That's it. Of course you can elaborate a bit along those lines, for example
by letting the name of the town and the name of the name chosen before hand
with globals and search on these globals.
Remi-Noel


"James Sutphin" <jsutphin (AT) earthlink (DOT) net> a écrit dans le message de news:
C1C8B39A.24411%jsutphin (AT) earthlink (DOT) net...

Thank you very much. I'll try that.

James


in article 45a3719b$0$24154$426a74cc (AT) news (DOT) free.fr, Remi-Noel Menegaux at
rnmenegaux_AT_free.fr wrote on 1/9/07 5:42 AM: