Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn more

View all

Sign in to view all badges

Livecycle over/underflow error

melissap509
Level 1
Level 1

I cannot seem to get past this error.  I have looked at the forums and still am getting either a script syntax error or the aritmetic error, depending on which way I change the script

Here is my script: (FormCalc)

if(NumericField1 ne 0 & HasValue(NumericField1)) then (NumericField1*NumericField12)elsenullendif

I am trying to multiply 2 fields and then all the multiplied fields are totaled - very simple "spreadsheet" function.  Can anyone tell me what I am doing wrong??

Thank you!!

MelissaP509

1 Reply
loather
Level 2
Level 2

I will guess your script is in the "calculate" event of a 3rd field.

You can add a bit more in the script to try to help you understand the error.

For information: Overflow means it calculated a value too large to handle and underflow means it calculated a value too small to handle. Either case suggests something is wrong because I guess you have "every day" kind of values in the hundreds/thousands/millions kind of range.

Try the following [I slightly extended your 'if' so it requires a value in NumericField12 also] and it should pop up a window showing the values of both fields before the calculation:

// show field values for debugging
xfa.host.messageBox(
  Concat("NumericField1 val: ", NumericField1, " NumericField12 val: ", NumericField12)
, null
, 3)

// calculate them
if(HasValue(NumericField1)
  & HasValue(NumericField12)
  & NumericField1 ne 0
  & NumericField12 ne 0) then
  NumericField1*NumericField12
else
  null
endif

Good luck!