How to use CountIF in a Progress ??

[Aesax]

Hi I'm new to this and I'm trying to use a "CountIF" condition in the "Value" field of my Progress...

My data source is a MSSQL Connection in which I have several tables and I the condition that I need is something like count if string equals something.

I've been trying several options but still can't make it work, I have something like:

CountIf(Table.Data == "String")

How is it done?

[Lech Kulikowski]

Hello,

Sorry, maybe we did not exactly understand your question. Could you explain your issue in more detail?

Do you need to use that condition directly in the query?

Thank you.