Round up formula help

Forum|Forum|6 years ago
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);
}

try67

Community Expert

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

O

omanbuxAuthor

Known Participant

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

try67Correct answer

Community Expert

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);
}

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded