3 Replies Latest reply: Jan 29, 2013 7:13 AM by leviwong RSS

    Percentage Not Calculating

      Hi Guys,

       

      I have a field : Call_Priority.

      It holds the following values

      <=7

      >7 <=14

      >14 <=21

      >21

      Ongoing

       

       

      I am trying to make a Straight Table diaplay the percentage of each of these values compared to the total.

       

      The Dimention is Call_Priority.

       

      Each field has a unique ID (fieldname ID)

       

      I tried this expression:

       

      =count(Call)Priority/count(ID)

       

      But this is producing 100% for all Call_Priorities. This isnt right.

       

      I think this is because it has Call_Priority as a dimention so the sum(ID) is calculating how many IDs are falling under each value (which will be the same as the count)

       

      I need an expression which will give me the percentage of the total selection that falls within each of the <=7.... etc values

       

      The % values should always add up to 100%.

       

      Any advice is appreciated.

       

      Thank you

       

      L