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

    Percentage of Gender

    Stuart Frew



      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?