I am just all sorts of confused on the median function. I just want to display the median of three numbers as a boundary on my gauge chart. I thought it would be like rangemedian(#,##,###) like the rangemax and rangemin functions, However, upon further research it's supposed to look like this (maybe?):
I just need to know how to set is up so I get the median of sum(x), sum(y), and sum(z).Thanks for all your help!
I believe the expression you want to use is RangeFractile - you can use it along with a fractile value of 0.5 and your three expressions. See the help entry below:
|rangefractile (0.5, above(sum(x),-1,3))||returns the median of the three results of the sum(x) function evaluated on the row below the current row, the current row and the row above the current row.|