4 Replies Latest reply on Aug 27, 2013 12:07 PM by teresamcgill

    Java Calculation for Acrobat PDF

    teresamcgill Level 1

      I need help with custom calculation script. Three cells (A,B,C,D) A, B and C are the data fields and D is the total field

       

      IF (A-B-C)>0    then D=0

      ELSE D=(A-B-C)*-1

       

       

      So if the total calculated produces a positive number, the field should read '0". BUT, if the total calculated produces a negative number, the field should read the actual calculated number (multiplied by –1 so the number shows as a positive number).