## Forum Discussion

MarkShnier__You

Qrew Legend

And do you mean Median, or will you settle for Average.

------------------------------

Mark Shnier (Your Quickbase Coach)

mark.shnier@gmail.com

------------------------------

MelissaFreel

2 years agoQrew Member

Mark: Yes, I mean median. I already used a query formula field to come up with an average.

Lordsman: I want to come up with a median of one field ACROSS multiple records. So I thought the query fields would help.

This formula gives me a textlist of the values I need and sorts them from low to high which is first step of calculating a median. I have two formula check boxes that create a filter in QueryOne. QueryTwo returns the list of values I need from field ID 2393. Now, I just need to have QB tell me what the middle value is:

var text QueryOne="{2030.EX.'True'} AND {4462.EX.'True'}";

var textlist QueryTwo=GetFieldValues(GetRecords($QueryOne,[_DBID_CUSTOMERS]), 2393);

Thoughts??

------------------------------

Melissa Freel

------------------------------