1 Reply Latest reply on Jul 15, 2010 8:52 AM by beardjeff

    daft calculation question!

    SiegeA68

      My apologies for such a basic question but i'm creating my first form and the following calculation gives rise to an arithmetic over/underflow!!?

       

      (NumericField7 / NumericField2) * 100

       

      How can i avoid this error message?

       

      Please advise

       

      Chris

        • 1. Re: daft calculation question!
          beardjeff

          The error message is coming from your denominator being initially undefined until a value is posted to NumericField2.

           

          The way around it is (in FormCalc):

           

          if (NumericField2>0) then (NumericField7/NumericField2)*100 endif

           

          This tells it to only execute the forumla when NumericField isn't 0 or null.