1 Reply Latest reply: May 15, 2014 10:12 AM by KeyserSoze _ RSS

    Issues with external lookup using dollar amounts

    jcapra _

      Hi, I am having an issue with an external lookup where one of the match fields is a dollar value.  The lookup source is an access database.  All match perfectly except anything with a 0.00 value.  No match.  I tried changing the column in the lookup so that the the value is a double, standard format, and 2 decimal places and it still doesn't work. 

       

      Any thoughts?