https://www.infopathdev.com:443/forums/142.aspxAre you exploring new features coming up in 2010? Share information and ask questions here!enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/88735.aspxMon, 08 Apr 2013 03:14:30 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:88735Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/88735.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=142&PostID=88735<p>&nbsp;I&#39;d use calculated values (expression boxes) - one with the value of each field - and hide the one you don&#39;t need based on conditional formatting using your checkbox. Does that make sense?</p>https://www.infopathdev.com:443/forums/thread/88681.aspxThu, 04 Apr 2013 20:59:03 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:88681RSharepoint0https://www.infopathdev.com:443/forums/thread/88681.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=142&PostID=88681<p>I&nbsp;am trying to display the monthly totalsavings value&nbsp;of the rows from a secondary data connection&nbsp;based on the dropdown selections on my form. My problem is the total depends on 2 fields.check if&nbsp;use_adjustedvalues field is&nbsp;no then sum savings field else sum adjustment field.Is it possible to&nbsp;query each row&nbsp;and take that value from either field to total?&nbsp;&nbsp;Any help would be appreciated.</p> <p>&nbsp;</p> <p>Thanks!</p>