8 Replies Latest reply: Jul 13, 2018 8:08 AM by Sunny Talwar RSS

    Maximum among the tables values

    Deepak K M

      Screenshot (40) - Copy.png

      i want to know the maximum of population and get the city value. This i could do easily with the following expression

      Only(If(Population=Max(Total (Population)),City))

       

      Screenshot (40).png

      But my question is when i have same value of population, then also i should get city ,but it should be break the tie taking GDP into consideration and look for highest gdp between max populatoin.

      for eg In the above pic i should get City=C has a value. Since Population of A and C is same , it is tie, then we need to consider gdP into account and Since C has more GDp, output should be City=C. How to get this?