9 Replies Latest reply: May 12, 2015 9:01 AM by Stuart Frew RSS

    Percentage of Gender

    Stuart Frew

      Hi,

       

      Having some issues with a dimensionless straight table; sure its something easy.

       

      My Data has the following columns

       

      CustomerID, Gender

      1111, Male

      2222, Male

      3333, Female

       

      How do I properly calculate the percentage of Male customer ID's? I seem to be able to calculate it fine but when selections are made the percentage does not make sense.

       

      =(count(distinct{$<Gender={'Male'}>}  CustomerID))

      /

      count( DISTINCT CustomerID)

       

      This gives 52% with no selections. When I choose Male in a Filter box it shows 100%

       

      BUT when I choose Female in a list box it shows 132%

       

      What am I doing incorrect?