I am using Math.floor in the Exit action of a field ((headwaterExistingMain10 is the field name) and this is the formula in Calculate action: if (headFtExistingMain10.rawValue==null)this.rawValue==nullelse this.rawValue = (Math.round(hweFtMain10.rawValue*10)/10)+(Math.round(headFtExistingMain10.rawValue*10)/10) and though the calculations work I'm getting this error message "illegal value: cannot assign 'True' to xfa[0].form[0].form1[0].page1[0].table1[0].row5[0].headwaterExistingMain10[0].#valu...

This formula worked but I'm trying to leave the field (headwaterExistingMain10) blank unless there is an amount in one of the fields in the formula using this.. if (headFtExistingMain10.rawValue==null)this.rawValue==nullelse this.rawValue = (Math.round(hweFtMain10.rawValue*10)/10)+(Math.round(headFtExistingMain10.rawValue*10)/10) ....When I Preview the form I get this error..."Illegal value: cannot assign 'True' to xfa[0].form[0].form1[0]0.page1[0].table1[0].row5[0]0.headwaterExistingMain10[0].#...

I'm trying to calculate the total of 2 fields which have been formatted using math.floor; I want to calculate the formatted amount of these 2 fields, NOT the rawValue. How can I do this? example: Field 1 rawValue = 700.44 Field 1 formatted value = 700.4Field 2 rawValue = .42 Field 2 formatted value = .4Total rawValue = 700.86 (rounded 700.9) Total formatted value = 700.8 ; this is what I need to do

I'm trying to add form field to the barcode but in the list of fields in the barcode setup the field itself is grayed out as an unsupported node. Is there any way around this "unsupported" issue?

Looking for code to re-create this Excel formula which identifies the lowest number in a table column and places it in a different field. ="Single Unit:" &CHAR(10)& IF(COUNT(AB17:AB23)>0,TEXT(ROUNDDOWN(MIN(AB17:AB23),0),"0") & " tons",IF(COUNT(AB24:AB27)>0,TEXT(ROUNDDOWN(MAX(Z17:Z23),0),"0") & " tons",IF(AND(ISNUMBER(G28),ISNUMBER(G29),ISNUMBER(G30),ISNUMBER(G31),MIN(G28:G31)<1),"LL","n/a")))

Along with rounding up I'm trying to set a the pattern of a field in a form based on the number entered. I.E. if the field is <10 then use 1 decimal; if 10 or greater use 0 decimals. So basically, if 0.47 is entered it will round to 0.5. Likewise if 2.84, it would round to 2.8. But if 10.85 is entered it would round to 11 and 25.83 would round to 26 because both are greater than 10. Can this be done?