https://www.infopathdev.com:443/forums/39.aspxNew to InfoPath? Search to see if your question has already been answered. If it has not, then ask it here or the appropriate topic forum.enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/89404.aspxWed, 01 May 2013 15:55:36 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:89404wilkies0106aw0https://www.infopathdev.com:443/forums/thread/89404.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=89404<p>&nbsp;Not sure if it&#39;s possible with an external data source, yet is your drop list format the same i.e. productname - number KG. if so you might be able to use an inbuilt substring function to extract the number. Then it would be a question of doing the math on that number. Might have to play around so that the extracted item is recognised as a number.<br /></p>https://www.infopathdev.com:443/forums/thread/89344.aspxTue, 30 Apr 2013 09:44:20 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:89344endless1120https://www.infopathdev.com:443/forums/thread/89344.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=89344I am drafting a from which helps me prepare a product formulation. 1. I have a drop down list where I select the product which lists data from an external datasource (SQL) 2. The datasource has a hierarchy structure (parentname/componentname) 3. When I select product (parentname), I get a listbox with all the component names and respective quantities measures. 4. These quantitie measures are per KG What I am trying to achieve is to get a calculated list box where I enter &quot;Total KG required&quot; and get my desired calculated output for all the component names/quantities etc. I suspect that my solution above may not be possible. If it is, I would love to hear your thoughts. Alternative approach to my challenge above would be much appreciated. Thanking you, AR