InfoPath Dev

I have on repeating table in my form.. It has two textboxes in that.

My Scenario is : 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..

Texbox1            Textbox2

33                       0          Less than 6000 So 0 in textbox2

678                     0          Less than 6000 So 0 in textbox2

5678                   389      It should have the value of 6000 - sum(Textbox1)

767                    767       From now on Textbox1 and Textbox2 should be similar..

878                    878

 These are rows in Repeating table.. User can insert how many they want..

 Can any one of you please help me....

Hello,

Please try giving Textbox2 the following default value formula:

(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) >= 6000)

 Alternatively, you could add a hidden field called RunningTotal whose default value is sum(../my:Textbox1| ../preceding-sibling::my:RepeatingGroup/my:Textbox1), and that would simplify the above formula to:

(../my:RunningTotal - 6000 - sum(../preceding-sibling::my:RepeatingGroup/my:Textbox2)) * (../my:RunningTotal >= 6000)