tag:blogger.com,1999:blog-558158604058309640.post3334623236618223735..comments2019-09-07T11:38:57.254-04:00Comments on InfoCore Advisor: Using D-Lookup functionRobert Buonocorehttp://www.blogger.com/profile/14950603502629460560noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-558158604058309640.post-61122843814884714122011-01-03T11:05:29.907-05:002011-01-03T11:05:29.907-05:00The Dlookup function would most likely return the ...The Dlookup function would most likely return the value in the format that it was stored in. I would check your table setup to make sure the rate is being stored as numeric and not as text. <br /><br />If you are still running into issues, you can force the system to treat the returned valued to be numeric by using a simple trick. <br /><br />Just using the + sign will not automatically treat the values as numbers. In fact, if txtField1 = 1 and txtField2 = 2, then <br />Expr1: [txtField1]+[txtField2] will return an answer of 12. It will just put the two values together.<br /><br />BUT, if you multiply the retured value by 1 and it will force it will assume you want it to be a number. In this example;<br /><br />Expr1: ([txtField1]*1)+([txtField2]*1)<br /><br />Will return a value of 3.<br /><br />Hope this helps.Robert Buonocorehttps://www.blogger.com/profile/14950603502629460560noreply@blogger.comtag:blogger.com,1999:blog-558158604058309640.post-55164883019076728822010-11-30T16:22:42.884-05:002010-11-30T16:22:42.884-05:00Thanks for the help. This worked great but I ran ...Thanks for the help. This worked great but I ran into a problem where the function returned the data as a text. This then gave me an error when I tried to add two values together. Any suggestions?John Buonocorehttps://www.blogger.com/profile/11544511710917157403noreply@blogger.com