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:

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 ?