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

Master Detail/Relationship (Compare numbers)

Started by dbrooks74, 21 May 2010 02:19:49 PM

Previous topic - Next topic

dbrooks74

I have two sets of lists.  Unfortunately the way the two scripts are written my filter is comparing two values one is using the thousands comma and one is not.  So two values could be 1250 and the other would be listed as 1,250.  How do I filter the list?  Am getting an error when I try to do the standard "this field  = this field".  I think one is set for text and the other is a #.  :-(

??? ??? ??? ??? ??? ??? ??? ??? ??? ???

MFGF

Try using the cast() function on one of the values to change its data type to match the other.  You should then be able to compare them successfully.

Regards,

MF.
Meep!