If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

conditionally show the values

Started by cognos.cognosbi@gmail.com, 19 Oct 2011 01:24:01 AM

Previous topic - Next topic

cognos.cognosbi@gmail.com

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.

MFGF

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

cognos.cognosbi@gmail.com