Skip to main content
Announcements
SYSTEM MAINTENANCE: Thurs., Sept. 19, 1 AM ET, Platform will be unavailable for approx. 60 minutes.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

expression in set analysis

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

10 Replies
tresesco
MVP
MVP

Try putting an equal sign and quotes, like:

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

MK_QSL
MVP
MVP

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

Not applicable
Author

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

tresesco
MVP
MVP

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

sushil353
Master II
Master II

Hi,

Try this:

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


HTH

Sushil

Not applicable
Author

Thanks

but I still have 0..

rustyfishbones
Master II
Master II

Try sharing the App so we can take a look

sushil353
Master II
Master II

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
Partner - Creator II
Partner - Creator II

Hai Frd Pls Snd Sample Qvw