Count conditional text Field

[frank1982]

Hi,

for the following table

I have to count the number of rows that NOT include the char 'M'.

I built a table with a Dimension, and the expression is the Count of rows:

How could I calculate the column '# Offerte disponibili'?

Thank you in advance.

Franco

[sunny_talwar · Accepted solution]

May be this

Count({<CD_SOURCING_FN_AUT = E({<CD_SOURCING_FN_AUT = {"*M*"}>})>} CD_SOURCING_FN_AUT)

[frank1982]

It works!

Great!

Thank you very much!

Franco

[frank1982]

I'm sorry, I have another question : how I have to write the expression if I would like to add another condition?

For example, I want to obtain the strings that don't include chars 'M' and string 'prova'.

thank you.

Franco

[sunny_talwar]

May be this

Count({<CD_SOURCING_FN_AUT = E({<CD_SOURCING_FN_AUT = {"*M*", "*prova*"}>})>} CD_SOURCING_FN_AUT)