How do you do a "count" based on specific item in a list

[#1]

In my example attached, I would like to count how many times, I have "Swiss Boat" as a supplier  ? quite simple I know but I am just starting today..

thanks

Ce message a été modifié par : jean-philippe favre

[Anonymous]

count(if(Supplier='Swiss Boat', Activity))
or

count({<Supplier={'Swiss Boat'}>}  Activity)

[MK_QSL]

SCRIPT....

LOAD

  RowNo() as NO,

  Supplier,

    Activity

FROM ..........

(Assuming that you know how to load an excel file...)

Now Create a text box and enter below in the expression..

=COUNT({<Supplier = {'Swiss Boat'}>}Supplier)

[alexandros17]

Here there is an example

[#5]

Thanks great

[#6]

Thanks to all.

[#7]

Ok now next level on a COUNT...I need to count the number of 24h card used, but on my list, 1 card could be used several times. in the document attached you can that we have 14 activities but only 9 cards ?

Questions :

How do I extract the number of 24h cards ?

How do I calculate the average use of those cards, in my example, it will be 1.55 (meaning 14 / 9) ?

Thanks