Simple calculation

[robertb87361850]

Hi I've got very simple question 🙂 please help.

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

Somebody could help ? 🙂

regards

Wieslaw

[ls_rbls]

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;

[robertb87361850]

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 ?

[Asim123]

What exactly are you trying to calculate?

You just want to sum up your fields like this?

[robertb87361850]

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

so: 100,1 + 2,2 - 53

[Nesa Nurani · Accepted solution]

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.

[robertb87361850]

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

[ls_rbls]

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

[try67]

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.

[try67 · Accepted solution]

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) : "";

[robertb87361850]

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

[try67 · Accepted solution]

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

[robertb87361850]

OK, thanks:)