Calculate median value

Highlighted
Previous Contributor

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

1 REPLY 1
Highlighted
Community Boss

RE: Calculate median value

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 ?

Nathan Rudman, Anaplan Model Builder