Skip to main content
Known Participant
February 8, 2019
Answered

Round up formula help

  • February 8, 2019
  • 1 reply
  • 1121 views

hi, i have setup my form total field to number & two decimal places so bellow formula answer showing 95.83. my request is i want to show that answer like 95.84.

1150 / 12 = 95.8333333

Also if i make another formula like (Total field value * 2), answer should be 191.68 & not 191.67

Cau pls help me to solve this issue. thanks..

This topic has been closed for replies.
Correct answer try67

OK, then you need to change it to a script, with this code:

var v1 = Number(this.getField("Text9").valueAsString) / 12;

event.value = roundUp(v1, 2);

And:

var v1 = Number(this.getField("Text10").valueAsString) * 2;

event.value = roundUp(v1, 2);

And place this code as a doc-level script (go to Tools - JavaScript - Document JavaScripts, and create a new item called "scripts"):

function roundUp(v, nDecimals) {

    return Math.ceil(v * Math.pow(10, nDecimals)) / Math.pow(10, nDecimals);

}

1 reply

try67
Community Expert
February 8, 2019

Are you using a script for this? If so, please post it.

omanbuxAuthor
Known Participant
February 9, 2019

hi, I'm sorry i'm not using any script & just used "simplified field notation "formulas for above to calculations.. (Text9/12) & (Text10*2). thanks..

try67
try67Correct answer
Community Expert
February 9, 2019

OK, then you need to change it to a script, with this code:

var v1 = Number(this.getField("Text9").valueAsString) / 12;

event.value = roundUp(v1, 2);

And:

var v1 = Number(this.getField("Text10").valueAsString) * 2;

event.value = roundUp(v1, 2);

And place this code as a doc-level script (go to Tools - JavaScript - Document JavaScripts, and create a new item called "scripts"):

function roundUp(v, nDecimals) {

    return Math.ceil(v * Math.pow(10, nDecimals)) / Math.pow(10, nDecimals);

}