Mean Mode Median

[FMPNewbie]

Is there any way to compute mode median on FMP.

[-Queue-]

In one field in one record, a field in a series of records, multiple fields? Please be much more specific.

[jrb12]

FMPNewBie, if by median you mean the mid-value in a list of ordered values. And your values are in a specific field in a found set of records. You could sort the records on the field in question and use the Status(CurrentFoundCount) function to retrieve the size of your list. Then pick out the mid-value using the Go to Record/Request/Page["Field Name"] script step. Where the "Field Name" field is a global containing Status(CurrentFoundCount) divided by 2.

If the found set length is an even number, you need to average this mid-value with the field value in the subsequent record.

Rather a course decription, I'm afraid but hope it can be of some help.

Cheers,

John.

[Tripod]

This is correct. Mdn is a PITA to calc, but this is indeed the correct way to do it. Middle value and such, this is the most direct way to do it, unfortunately. I know someone who used this as an excuse to move a project into access. Can you imagine? Of course, she could not even run a script, but she loves access. Glutton for punishment, I guess...

--Tripod