Hi,I'm trying to create a metric which shows the median purchase value. The range of sums can be quite large, so the mean can be skewed by large orders reducing its usefulness.I have tried using the median function but it isn't behaving as I would expect. What I would ideally like to do is have a me...