Wildmatch within set analysis.

[#1]

The below set analysis is not working.I want to do the wildmatch  for Tech and I see the error mark near the % sign ({'*Tech*'}>}%))

=num(avg({$<Name={'*Tech*'}>}%),'#,##0%')

Thank you very much.

[tresesco]

num(avg({$<Name={'*Tech*'}>} FieldName or Expression),'#,##0%')

In place of fieldname/expression, you are putting % . What is this % ?

[rubenmarin · Accepted solution]

Hi, I crated a sample data with 'Name' and '%' as fields and this expression works:

=num(avg({$<Name={'*ABS*'}>}%),'#,##0%')

So I don't know why it's not working for you... [%] is a field name?

[#4]

Thank you.It worked for me .