Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Have you tried enclosing the string based variable in single quotes? Like
=Avg( {$<[Year]={$(varReportYear)}, [Code]={$(varTitleYear)}, [StringField] = {'$(varString)'} >} [Total Eur])
Have you tried enclosing the string based variable in single quotes? Like
=Avg( {$<[Year]={$(varReportYear)}, [Code]={$(varTitleYear)}, [StringField] = {'$(varString)'} >} [Total Eur])
Thank You, Spot On.