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
------------------------------