3 Replies Latest reply on Nov 19, 2018 7:01 AM by K Chandler

    Show a simplified ratio on a dashboard

    K Chandler

      Hi

       

      I would like to show the ratio of female to male employees as a simplified ratio in the form female:male on a dashboard. While it is easy to show actual number of females:actual number of males, I am struggling to work out how to put this in a simplified form, e.g. 5 females and 10 males is a ratio of 1:2. Does anyone know a way to determine the greatest common factor of both sums so that I can then use that to calculate the simplified ratio?

       

      The data comprises 1 row per person, e.g.

       

      name       gender

      fred          male

      susan      female

      john         male

      ....

       

      Thanks

       

      K