Sum of Count

[andyrebs]

Hi

I have a problem, I know that it is very simple, but it's Friday and I can't get out of this little trouble.

I know the Count function, what is the correct expression to have the total of counts. To be more clear I would like to have a percentage (count(field)/sum of count(field). The field is a text field

Thanks again.

Andrea

[swuehl · Accepted solution]

I assume you are using this expression in a chart object with a dimension.

To disregard the current line dimension value, you can add TOTAL qualifier to your count() function

=count(field) / count(TOTAL field)

TOTAL qualifier can also be used with field list, like TOTAL<DIM1,DIM2>, see the Help for more detail.

[andyrebs]

I knew it was simple, I forgot TOTAL.

I use this expression in a list box, if it is possible I would like to transform the expression in a bar chart, do you know how I can set it.

Anyway Thank you.

Andrea

[swuehl]

Well, if you are using field as field in your listbox and above expression, I would just try field as dimension in a bar chart and the above expression as expression.

[andyrebs]

Thank you, I will check.