Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
count(if(Supplier='Swiss Boat', Activity))
or
count({<Supplier={'Swiss Boat'}>} Activity)
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)
Here there is an example
Thanks great
Thanks to all.
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