expression in set analysis

[#1]

Hi All

I have a problem with expression in set analysis.

If I write:

Count(DISTINCT {$<RulesType={'NOT_OVERRIDE'}, Quarter ={ '1Q 12' } >} crrId)

it works well.

If I write

Count(DISTINCT {$<RulesType={'NOT_OVERRIDE'}, Quarter ={ $ ('1Q ' & right(Year,2)) }>}crrId)

where Year =2012, it doesn't work.

What's wrong?

Thanks

Luca

[CELAMBARASAN]

Hi,

Try

Count(DISTINCT {$<RulesType={'NOT_OVERRIDE'}, Quarter ={ '1Q $(=right(Year,2))' }>}crrId)

Above will work if Year is a variable or Year field has only one value selected.