4 Replies Latest reply on Sep 11, 2015 12:07 PM by Beachbum2015

    Calculation No Longer Works if a Value in a Field is deleted

    Beachbum2015 Level 1

      I've got an issue where a FormCalc calculation stops working if I delete a value in a field that is part of the formula.

       

      Here's a link to the test form:  https://www.dropbox.com/s/3w6weyd3bp5dfss/Test_Totals.pdf?dl=0

       

      When I enter the values in the table as below, the calculation in the CASH DUE EMPLOYEE field works fine.

      Total_B.jpg

      If I delete the value in the CASH ADVANCE field, the calculation in the CASH DUE EMPLOYEE field doesn't recalculate.  In the below example, I deleted the cash advance, so the CASH DUE EMPLOYEE should be $100, but yet the field goes blank.

      Total_A.jpg

      Here's the FormCalc script in the CASH DUE EMPLOYEE field:

       

      if (Table1.Row1.Total_E_Exp.rawValue > Table1.Row2.Cash_Adv.rawValue) then

         Cash_Due_Employee.rawValue = Table1.Row1.Total_E_Exp.rawValue - Table1.Row2.Cash_Adv.rawValue

      else

         Cash_Due_Employee.rawValue = 0

      endif

       

      I just can't figure out why the field isn't recalculating after I delete the value in the CASH ADVANCE field.

       

      Any help would be appreciated.

       

      Thanks