https://www.infopathdev.com:443/forums/41.aspxIf you're not sure where to ask your question, ask it here. If necessary, our moderators will make sure it gets classified in the correct board.enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/82886.aspxThu, 20 Sep 2012 17:18:15 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:82886Shining Star0https://www.infopathdev.com:443/forums/thread/82886.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=82886Working like a Charm! You are Awesome! Thanks a lot Jimmy...https://www.infopathdev.com:443/forums/thread/82883.aspxThu, 20 Sep 2012 16:42:11 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:82883Jimmy0https://www.infopathdev.com:443/forums/thread/82883.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=82883<p>Hello,</p><p>Please try giving Textbox2 the following default value formula:</p><blockquote><p>(sum(../my:Textbox1| ../preceding-sibling::my:RepeatingGroup/my:Textbox1) - 6000 - sum(../preceding-sibling::my:RepeatingGroup/my:Textbox2)) * (sum(../my:Textbox1| ../preceding-sibling::my:RepeatingGroup/my:Textbox1) &gt;= 6000)</p></blockquote><p>&nbsp;Alternatively, you could add a hidden field called&nbsp;<strong>RunningTotal</strong>&nbsp;whose default value is <strong>sum(../my:Textbox1| ../preceding-sibling::my:RepeatingGroup/my:Textbox1)</strong>, and that would simplify the above formula to:</p><blockquote><p>(../my:RunningTotal - 6000 - sum(../preceding-sibling::my:RepeatingGroup/my:Textbox2)) * (../my:RunningTotal &gt;= 6000)</p></blockquote>https://www.infopathdev.com:443/forums/thread/82872.aspxThu, 20 Sep 2012 14:03:54 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:82872Shining Star0https://www.infopathdev.com:443/forums/thread/82872.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=82872<p>I have on repeating table in my form.. It has two textboxes in that. </p> <p>My Scenario is :&nbsp;I have to do calculation for second text box. If the sum of textbox1 is below 6000(this number is constant) textbox2 value will be 0 otherwise sumof textbox1 exceeds 6000 then textbox1 value will be copied to textbox2. But I dont know how to implement below scenario..</p> <p>Texbox1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Textbox2</p> <p>33&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Less than 6000 So 0 in textbox2</p> <p>678&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Less than 6000 So 0 in textbox2</p> <p>5678&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 389&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; It should have the value of 6000 - sum(Textbox1)</p> <p>767&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 767&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; From now on Textbox1 and Textbox2 should be similar..</p> <p>878&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 878</p> <p>&nbsp;These are rows in Repeating table.. User can insert how many they want..</p> <p>&nbsp;Can any one of you please help me....</p> <p>&nbsp;</p>