https://www.infopathdev.com:443/search/SearchResults.aspx?o=DateDescending&tag=lookup,Formula,look,set,Field,list,id&orTags=0Search results matching tags 'lookup', 'Formula', 'look', 'set', 'Field', 'list', and 'id'en-USCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/p/32012/109372.aspx#109372Fri, 03 Feb 2017 15:48:37 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:109372Matt LeonI 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 by the value of "SQF", "Total Cost" is instead being divided by the ID of "SQF". Furthermore, I have another lookup field called "Campus". It's action rule has the condition: None - Run when field changes. It's action is: Set a field's value: "SQF" = "Campus". This rule works, because it uses their matching IDs; both "Campus" and "SQF" are on the same list. Is there a way to make it so that "Total Cost" is divided by the actual value of the square footage, not the ID, AND for "Campus" to set "SQF" equal to itself using their shared ID? Thank you,