Set Analysis: syntaxes, functions.

[giovannarugerio]

I'm trying to count how many emails with a number in the username are, and display it in a KPI.

I tried with this 

count({1<email ={"$(= purgechar(email,'0123456789')"}>)}email)

but it's not working.

[m_woolf]

You might want to create a flag in script to make this easier.

if(email = purgechar(email,'0123456789'),1,0) as EmailNum,

Then the expression becomes:

count({1<EmailNum = {1}>)}email)

[sunny_talwar]

or may be this

Count({1<email = {"=Len(KeepChar(Only({1} email), '0123456789')) > 0"}>} email)