Custom Calculation Help

Community Beginner ,
Nov 13, 2018 Nov 13, 2018

Copy link to clipboard

Copied

I need help converting the following equation (taken from my excel worksheet) to work in my form in Adobe DC:

SUM(D13:D15)/15*C13

TOPICS
Acrobat SDK and JavaScript

Views

121

Likes

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more

Adobe Community Professional , Nov 13, 2018 Nov 13, 2018
It could be something like:// Get the field values, as numbersvar D13 = +getField("D13").value;var D14 = +getField("D14").value;var D15 = +getField("D15").value;var C13 = +getField("C13").value;// Perform the calculation and set this valueevent.value = (D13 + D14 + D15) / 15 * C13Replace "D13" etc. in the statements that use getField with the actual field names.If using the simplified field notation option, it would be:(D13 + D14 + D15) / 15 * C13but again you'd use the actual field names. If th...

Likes

3 Replies 3
Most Valuable Participant ,
Nov 13, 2018 Nov 13, 2018

Copy link to clipboard

Copied

Likes

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Adobe Community Professional ,
Nov 13, 2018 Nov 13, 2018

Copy link to clipboard

Copied

It could be something like:

// Get the field values, as numbers

var D13 = +getField("D13").value;

var D14 = +getField("D14").value;

var D15 = +getField("D15").value;

var C13 = +getField("C13").value;

// Perform the calculation and set this value

event.value = (D13 + D14 + D15) / 15 * C13

Replace "D13" etc. in the statements that use getField with the actual field names.

If using the simplified field notation option, it would be:

(D13 + D14 + D15) / 15 * C13

but again you'd use the actual field names. If the field names have spaces, punctuation, or certain other non-alphanumeric characters, you have to escape each such character with a backslash when using this option.

Likes

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Community Beginner ,
Nov 14, 2018 Nov 14, 2018

Copy link to clipboard

Copied

Thank you so  much! Worked perfectly!

Likes

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more