Highlighted

## Simple calculation

Explorer ,
Oct 05, 2020

Copied

How to make a simple calulation in attached file: B.5 = B.2 + B.3 - B.4.

Somebody could help ? 🙂

regards

Wieslaw

Most Valuable Participant
| Most Valuable Participant

Yes. The proper way of doing it is to set the field's Format to Number with that pattern.

TOPICS
PDF forms

Views

100

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

## Simple calculation

Explorer ,
Oct 05, 2020

Copied

How to make a simple calulation in attached file: B.5 = B.2 + B.3 - B.4.

Somebody could help ? 🙂

regards

Wieslaw

Most Valuable Participant
| Most Valuable Participant

Yes. The proper way of doing it is to set the field's Format to Number with that pattern.

TOPICS
PDF forms

Views

101

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
Oct 05, 2020 0
12 Replies 12
Oct 05, 2020

Copied

In the calculate tab you can use Use the built-in feature "Value is the  sum(+) of the following fields:", or you can use Simplified Field Notation:

``(B\.2+B\.3)-B\.4``

Or a custom calculation script of the B.5 field:

``event.value = (thisgetField("B.2").value + thisgetField("B.3").value) - (thisgetField("B.4").value;``

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
Oct 05, 2020 0
Explorer ,
Oct 06, 2020

Copied

Unfortunately it doesnt't work. Problem should be names of the textfields: "Text6.0", "Text6.1", Text6.2 or my own format script, I don't know. Could you look at attached file ?

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
Oct 06, 2020 0
Contributor ,
Oct 06, 2020

Copied

What exactly are you trying to calculate?

You just want to sum up your fields like this?

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
Oct 06, 2020 0
Explorer ,
Oct 06, 2020

Copied

In field '104.' I need simple calculation: field '14'. + field '23' - field '32'.

so: 100,1 + 2,2 - 53

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
Oct 06, 2020 0
Engaged ,
Oct 06, 2020

Copied

Try this code as custom calculation script of field '104'

var c1 = parseInt(this.getField("Text6.0").value);
var c2 = parseInt(this.getField("Text6.1").value);
var c3 = parseInt(this.getField("Text6.2").value);
event.value = c1+c2-c3;

You will get rounded result, not sure if thats what you looking for but give it a try.

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
Oct 06, 2020 1
Explorer ,
Oct 06, 2020

Copied

Thank you very much :), it works but small problem is fact that result shouldn't be rounded 🙂

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
Oct 06, 2020 0
Oct 06, 2020

Copied

IF you're using  the example JavaScript that I posted earlier for you, I made an error.

I write "thisgetField". Somehow I missed the period when I was typing. It should read :

this.getField

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
Oct 06, 2020 0
Most Valuable Participant ,
Oct 06, 2020

Copied

The issue is the way you entered the numbers into the fields. Since you used a non-standard notation system (commas as the decimal separators), and not through a regular Number format option, you can't use those values directly in a calculation. You have to first convert them to the format JS recognizes, which is "1234.56", ie. no thousands separators and a period as the decimal separator.
Also, the field names you're referring to in the code under "Text6.10" don't exist.

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
Oct 06, 2020 0
Most Valuable Participant ,
Oct 06, 2020

Copied

Use this code:

``````var v1 = Number(this.getField("Text6.0").valueAsString.replace(",", "."));
var v2 = Number(this.getField("Text6.1").valueAsString.replace(",", "."));

// Set this field value
event.value = ((v1) !== 0) ? (v1 + v2) : "";``````

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
Oct 06, 2020 1
Explorer ,
Oct 06, 2020

Copied

Super ! one more question, is it possible to replace full stop with a comma in result ? I would like to get "49,3" not "49.3".

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
Oct 06, 2020 0
Most Valuable Participant ,
Oct 06, 2020

Copied

Yes. The proper way of doing it is to set the field's Format to Number with that pattern.

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
Oct 06, 2020 1
LATEST
Explorer ,
Oct 06, 2020

Copied

OK, thanks:)

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
Oct 06, 2020 0
Resources