6 Replies Latest reply on Nov 1, 2016 8:13 AM by CalicoCat5000

    Stop Automatic Calculation Rounding or set None format category to two decimals?

    CalicoCat5000

      Hi, how do you stop automatic rounding in a calculation result?  The results field needs to display the actual unrounded number with two decimal points (it is a currency), and I have a simple multiplication calculation script:

       

      var v1 = this.getField("Construction").value;

      event.value = v1 * .001;

      if ((event.value == 0) && (getField("Construction").valueAsString === "")) event.value = "";

       

      When the format category is set as Number with two decimal places, the result is automatically rounded.  When the format category is set as None, the result is unrounded but there are more than two decimal places.  What should be done to display the actual unrounded number with a maximum of two decimal places?