Set Criteria

[#1]

Hi

I am averaging a euro value across a variable defined set, in general this works well:

=Avg( {$<[Year]={$(varReportYear)}, [Code]={$(varTitleYear)}>} [Total Eur])

However, when I add a third variable which is string based;  I get a result if the value is a single word e.g. "Brown" but don't if it contains spaces as in "Smith - London"

Any ideas would be helpfull.

Jim

[swuehl · Accepted solution]

Have you tried enclosing the string based variable in single quotes? Like

=Avg( {$<[Year]={$(varReportYear)}, [Code]={$(varTitleYear)}, [StringField] = {'$(varString)'} >} [Total Eur])

[#3]

Thank You, Spot On.