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/65886.aspxTue, 12 Apr 2011 18:42:09 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:65886dms.WebDev0https://www.infopathdev.com:443/forums/thread/65886.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=65886<p><strong>Update:</strong>&nbsp; This can be done.&nbsp; I realized there are several ways to approach it.&nbsp; What I ended up doing was adding a check box&nbsp;control to the repeating table to indicate TRUE if it was a row I wanted to effect the&nbsp;value change&nbsp;in.&nbsp; The problem I had getting it to work stemmed more from forgetting to add a couple other rules/conditions that were necessary.&nbsp; I wasn&#39;t being specific enough.</p>https://www.infopathdev.com:443/forums/thread/65885.aspxTue, 12 Apr 2011 18:07:35 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:65885dms.WebDev0https://www.infopathdev.com:443/forums/thread/65885.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=65885<p>What I&#39;d like to do is have <strong>txtField1 </strong>in my example below, in first row and last row only be equal to 75% of the value of txtField1 in the rows between the 1st and last rows.&nbsp; I am determining which txtField1 value to change in a row based on the value of its&nbsp;corresponding&nbsp; datepicker1 value.&nbsp; If datepicker1 value equals a date value of another field (outside this particular repeating table, say datepicker2) then calculate a different value for txtField1.</p> <p>Is this possible to do in a repeating table when the variables are the same for all rows?&nbsp; Or must I create a new variable and exclude it from the repeating table to accomplish this?&nbsp; I can get the formula to work but it changes all txtField1&#39;s no matter what the date condition is so I can&#39;t tell if it&#39;s not working because I&#39;m putting my datepicker conditions in the wrong place or because the fact that txtField1 is in a repeating table....??</p> <p>Example - 1 repeating table (all fields are same in each row)</p> <p>&nbsp; Row 1 controls are datepicker1,&nbsp; <strong>txtField1= (.75 * </strong>txField4<strong>),</strong>&nbsp;&nbsp; txtField2 and txtField3. (each txtField is decimal data type).<br />&nbsp; Row 2 controls are datepicker1,&nbsp; txtField1 = (txtField4),&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; txtField2 and txtField3. (each txtField is decimal data type).<br />&nbsp; Row 3 controls are datepicker1,&nbsp; txtField1 = (txtField4),&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; txtField2 and txtField3. (each txtField is decimal data type).<br />&nbsp; Row 4 controls are datepicker1,&nbsp; <strong>txtField1= (.75 * </strong>txtField4<strong>),</strong>&nbsp; txtField2 and txtField3. (each txtField is decimal data type).</p>