2 Replies Latest reply on Aug 21, 2013 2:04 PM by dongfang yang

    Want to Show the percentage of Diversity

    ramaswamy.suryanarayanan

      I want to show one number.  I have the table with person_id, ethinic_category.

      ethinic_category has 'Asian (Not Hispanic or Latino)',

                                        'Native Hawaiian/Other Pacific Islander(Not Hispanic/Latino)',

                                        'Black or African American (Not Hispanic or Latino)',

                                        'Native Hawaiian/Other Pacific Islander(Not Hispanic/Latino)',

                                        'Hispanic or Latino',

                                        'Two or More Races (Not Hispanic or Latino)'

                                         White (Not Hispanic or Latino)

       

      Count person_id where ethinic_category is other than  White (Not Hispanic or Latino) divide by

      Overall count of person_id.

       

      How to acheive this.  Please help.