Sum two fields then Divide by 2

(JJPC MCKTOTAL1 + JDPC MCKTOTAL1)/2

Can someone provide a Script for me to evaluate?

Thank you

This topic is closed to new replies. Start a new post to keep the conversation going.

try67Correct answer

Community Expert

The basic structure of the script would be:

var v1 = Number(this.getField("FieldName1").valueAsString);
var v2 = Number(this.getField("FieldName2").valueAsString);
event.value = (v1+v2)/2;

Community Expert

No script required, you can use the simplified notation:

(JJPC\ MCKTOTAL1 + JDPC\ MCKTOTAL1) * 0.5

The backslash is used to escape the space character.

Translate

Acrobate du PDF, InDesigner et Photoshopographe

Inspiring

You could put your calculation into the "Simplified Field Notation" method option.

If I remember correctly adding a number to itself and dividing by 2 will result in the number.

Have you looks at any of the free tutorials or videos on form creation?

Translate

Community Expert

If the field names contain spaces, though, you'll need to escape them, like this:

JJPC\ MCKTOTAL1

Translate

Sign up