Hi,
pls take a look into the below example and help me
i have case statement like:
case when
?param1? is between ([modelname]. [a] . where [modelname]. [a].[c] ='d' )
and
([modelname]. [a] . where [modelname]. [a].[c] ='e' )
then ('Y')
else ('N')
end
when i add and validate this condition iam getting an error. any one can suggest on the same please
Thanks In Advance,
Anu
I think Error is because of the where statement u included. Its not Cognos syntax.
Thank You!
cOULD YOU PLEASE POST YOUR FINAL CASE STATEMENT.THANKS
i couldn't complete the statement. can any one suggest on the same requirement with out using where clause in cognos.
Quote from: srinu_anu2007 on 21 Aug 2012 05:46:47 AM
i couldn't complete the statement. can any one suggest on the same requirement with out using where clause in cognos.
What on earth are you trying to code? The when part should contain a boolean expression.
([modelname]. [a] . where [modelname]. [a].[c] ='d' )
is bullocks..