Master Detail/Relationship (Compare numbers)

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