Percentage Not Calculating

[#1]

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

[Gysbert_Wassenaar · Accepted solution]

try count(ID)/count(total ID)

[swuehl]

Try

=count(Call_Priority) / count(TOTAL Call_Priority)

and set the format in number tab to show percentage.

[#4]

Both work perfectly, unfortunately only one correct answer allowed!

Thank you for your help guys.

Each day i seem to learn just a little more!

Regards

L