Is there some way to generate a Median value…

3.28K viewsFormulas and Functions
0

when doing a Datalink summarization. There are options for sums, averages, minimums and maximums. I’d like to calculate the values exactly midpoint in the resulting range.

0

My co-worker just passed me a good suggestion. You can import with the Min and Max summarization methods selected, and then add a third item and write a formula that takes the Min and Max values and averages them. That would do the trick.

-Mike

0

Hi Genie – Thanks for your post. I will add your request to add ‘median’ to the list of summarization methods in DataLink. It is a good suggestion.

A workaround would be to import the data into a separate 2D matrix, and then use a combination of the Select and median function against the range of data to find the median. Feel free to post again or email [email:37nbufbv]support@quantrix.com[/email:37nbufbv] if you need additional assistance.

-Mike

Latest Questions