Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try putting an equal sign and quotes, like:
Quarter ={" $ (='1Q ' & right(Year,2))" }>}
Count(DISTINCT {$<RulesType={'NOT_OVERRIDE'}, Quarter ={ "$ (='1Q ' & right(Year,2))" }>}crrId)
thanks for your reply, but doesn't work, I have 0 (result has to be 4)
That could be checked if you could post your sample app here.
Hi,
Try this:
Count(DISTINCT {$<RulesType={'NOT_OVERRIDE'}, Quarter ={' $ ('1Q ' & right(Year,2))' }>}crrId)
HTH
Sushil
Thanks
but I still have 0..
Try sharing the App so we can take a look
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
Hai Frd Pls Snd Sample Qvw