How to count a specific value in collection

[vandekamp]

Hello,

I have a collection with 4 columns. I want to count how many times a specific value appears in the 4rd column. I've tried many things but never get the good result : I tried with Filter and Append (see attachmenst) but it doesn't work.
My collection: LogsGlobaux
4rd Field: ETAT_PLI
Value that I want to count: Vérifié

What's the best method to get that?

Thank you very much.

 

[sivagelli]

'Filter Collection' returns a collection with filtered rows. The filter query should be: "ETAT_PLI = 'Vérifié'", just the field name not the collection name dot field name. Now, on the output collection use 'Count Rows' to get the count of rows with text "Vérifié".

I am not sure why you are using 'Append' here.