Median value changing with sort order

I’m using the Median function in a Single Value element, and I’m finding that the value returned changes if I change the sort order of the column that it’s calculated on in the parent table is changed!? Surely the function is doing its own ordering of values before determining the median and not relying on physical sort order of the data?

@vtigheo - Welcome to our community!

This certainly sounds odd. I would imagine the end-result of Median() should remain the same when you change the sort direction of the column we’re looking at.
Could you share more about your layout between parent table and the SV element? Are there groupings in the parent table? On the SV element do you have AGGREGATE VALUES checked and are you pointing to the correct grouping level in the parent?