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.raw...

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(headF...

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 raw...

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") & " t...

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 e...