Calculate median value
Hello, I'm trying to calculate a median value taking into account several dimensions. I'm using the RANK function but the values retrieved are incoherent regarding my dimensions. Here are the steps followed: - calculate a rank - calculate a min and max rank - calculate the median rank = ROUND((Min Rank + Max rank) / 2) Can you please give me a hint on solving this issue ? Thank you in advance for your help. Best regards. Gabriela PROFIR
Tagged:
0
Answers
-
Hello,
it seems,given your description, that your issue is in the way you acquire you rank values but you do not show how you do that.
Can you elaborate ?0