COGNOiSe.com - The IBM Cognos Community

Hi,

i have a list with values 1,2,3,4,5,6 like this.my requirement is if select in prompt we should show only even values.if i select odd show odd values only.how can achieve this.

Thanks And Regards
Cool Cognos.

You could drive a boolean variable using an expression utilising the mod() function (which returns the remainder of a division)

Your expression could be   mod([value],2) = 0

This will be true for even values and false for odd values, and you can use this to conditionally show or hide the values, depending on how your prompt is set.

Regards,

MF.

Thanks MFGF....