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

[tresesco]

Try putting an equal sign and quotes, like:

Quarter ={" $ (='1Q ' & right(Year,2))" }>}

[MK_QSL]

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

[#4]

thanks for your reply, but doesn't work, I have 0 (result has to be 4)

[tresesco]

That could be checked if you could post your sample app here.

[sushil353]

Hi,

Try this:

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

HTH

Sushil

[#7]

Thanks

but I still have 0..

[rustyfishbones]

Try sharing the App so we can take a look

[sushil353]

One more try to the below.. if that wont work it is better to post app

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

HTH

Sushil

[arjunkrishnan]

Hai Frd Pls Snd Sample Qvw