Calculation won't work with digits when opened in browser

Question

I have a file with several calculations in - see attached file.

But one calculation works only partly - the field 'Intervalløn beregnet'.

The calculation-script is:

var q = getField("Aftalt timeløn").value;
var n = getField("Reguleringsprocent").value;
event.value = q*1924/n;

'Aftalt Timeløn' is a field that can be filled with a number, format is a number with two digits.

'Reguleringsprocent' is a field with a fixed numer, format number/no format, digit-seperater , or . (- none of these has made the soution for me)

The problem:

The file works fine in Adboe (at least at my pc)

The file works fine in browser (Chrome), as long as the number filled in has no digits.

The fault appears, if theres digits added in the number filled in - then the result just shows 'nan'

How can I get the field to work properly?

Nesa Nurani · Accepted Answer

Ok - I can see that it'll do the trick.
But it's not me who shall put in the number - and here in Denmark no one use that format.
Is there a way to make it accept the 158,59?

all other calculations work fine with the comma.

Assuming you use comma as decimal point and no thousand separator as format, you can convert comma to dot in your script like this:

var q = this.getField("Aftalt timeløn").valueAsString.replace(",", ".");
var n = this.getField("Reguleringsprocent").valueAsString.replace(",", ".");

q = Number(q);
n = Number(n);

Bernd Alheit · Answer

You will get NaN when n is zero.

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