9 Replies Latest reply: Feb 25, 2016 3:50 PM by Ankit Luthra RSS

    Calculating %Female out of Total

    Ankit Luthra

      Hello,

       

      I am trying to calculate % of females out of my total population. My excel file has columns like Name, ID,....... Gender, etc. and each ID has a gender (male or female).

       

      I tried applying the following formula but it's not working:-

      Sum([Gender]={'Female'}) / Sum([Gender]={'Female'}) + Sum([Gender]={'Male'})

       

      Thoughts?

       

      Thanks!

      Ankit