14 Replies Latest reply on Oct 11, 2016 12:37 PM by Vamsi Immadisetty

    Calculate highest Version average

    Vamsi Immadisetty

      Hi I wanted to calculate Maximum version average. Let say my date is like this. 

       

      RID                VERSION

      1434577           4.323.32

      1434578           4.9.67

      1434579           4.323.32

      1434580           5.6.435

      1434581           6.1.2.99

      1434582           6.1.2.99

      1434583           6.1.2.99

      1434584           6.1.2.99

      1434585           6.1.2.99

      1434586           6.1.2.99

      1434587           6.1.2.100

      1434588           6.1.2.103

      1434589           6.1.2.103

      1434590           6.1.2.103

       

      Version 6.1.2.99 repeated more number of times. I am expecting to display on sheet as 6.1.2.99  -  42.85%  . I don't want to display rest of the versions and their percentages.