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

    daft calculation question!


      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



        • 1. Re: daft calculation question!

          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.