Search - InfoPath Dev Sign in | Join | Help InfoPath Dev InfoPath Dev is dedicated to bringing you the information and tools you need to be successful in your Microsoft Office InfoPath development projects. Home Blogs Forums Photos Downloads Search More Search Options Page 1 of 1 (3 items) Re: Use a lookup field's value, NOT its ID, in a math formula. That worked perfectly. So, is the expression "../d:ID = current()/../my:SQF" a go to for this kind of issue? If so, and someone else needs to do the same thing, I have attached quick how to for where this expression goes. Posted to Newbie Questions (Forum) by Matt Leon on 02-03-2017 Re: Use a lookup field's value, NOT its ID, in a math formula. I did try to follow the steps from that link yesterday, but for some reason the math would return "NaN", "Infinity", "", or the "Total Cost"/ ID. After my failed attempts, I just figured that the link was only showing how to get the field to display the lookup value instead of displaying the lookup ID. Posted to Newbie Questions (Forum) by Matt Leon on 02-03-2017 Use a lookup field's value, NOT its ID, in a math formula. I have a text control called "Total Cost". It's action rule has the condition: None - Run when field changes. It's action is: Set a field's value: "$/SQF" = "Total Cost" / "SQF". "$/SQF" is a text field. "SQF" is a lookup field. My issue is that instead of being divided ... Posted to Newbie Questions (Forum) by Matt Leon on 02-03-2017 Page 1 of 1 (3 items) Copyright © 2003-2019 Qdabra Software. All rights reserved.View our Terms of Use.