case satement

[srinu_anu2007]

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

[HalfBloodPrince]

I think Error is because of the where statement u included. Its not Cognos syntax.

[srinu_anu2007]

Thank You!

[barrysaab]

cOULD YOU PLEASE POST YOUR FINAL CASE STATEMENT.THANKS

[srinu_anu2007]

i couldn't complete the statement. can any one suggest on the same requirement with out using where clause in cognos.

[blom0344]

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..