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

Data Validation - Help!

Started by OSCARCog, 06 Oct 2015 10:00:00 AM

Previous topic - Next topic

OSCARCog

Hello Cognos Gurus!

I am trying to set up a data validation whereby if a user in Contributor selects a certain value from a formatted d-list a warning message pops up when the grid is validated.

I have tried creating a message-only data validation as follows: IF COA = 91411000 OR COA = 91412000 THEN 0 ELSE 1

However when testing in Contributor this validation never takes effect - can anyone indicate where I am going wrong? Is it not possible to do what I am trying to do?

TIA for any assistance/advice provided!

Rgds,
OSCAR

Danno

If the values are you writing against are from a drop down/lookup dlist then you need to use the ordinal values of the dlist items and not the values themselves.  I use these all the time. However if you can clarify this a bit further it would be easier to provide feedback.

OSCARCog

Danno, thanks very much. Using the item id's of the d-list items in the validation expression works perfectly.

Much appreciated :)

Regards,
Oscar.

Danno