Fillable form with math formula not working

[Thomas33346017q11r]

Hello all,

I am trying to add a math formula to a Fillable pdf and I am running into some issues. I have taken a formula from excel and need it to work inside of this pdf with no luck. I've got this portion of the formula to work: G29*((G30-G28)/(G30-G31)) I need this equation taken to the power of 0.54. Is there anyone who can help me with this?

[try67 · Accepted solution]

OK, then you must switch to using a script, such as this one (note you must also take into account the situation where G30 equals G31, to avoid division by zero):

var G28 = Number(this.getField("G28").valueAsString);
var G29 = Number(this.getField("G29").valueAsString);
var G30 = Number(this.getField("G30").valueAsString);
var G31 = Number(this.getField("G31").valueAsString);

var v1 = (G30-G31);
if (v1==0) event.value = "";
else {
	var v2 = (G30-G28);
	var v3 = G29*(v2/v1);
	event.value = Math.pow(v3, 0.54);
}

[try67 · Accepted solution]

Ah, OK, that makes more sense... Then change these two lines:

var v3 = G29*(v2/v1);
event.value = Math.pow(v3, 0.54);

To:

var v3 = (v2/v1);
event.value = G29*Math.pow(v3, 0.54);

[try67]

Math.pow(base, exponent)

[Thomas33346017q11r]

Sorry I'm very "dumb" when it comes to this, I would input what you typed where? 

[try67]

Are you using a script to perform the calculation? If so, post your code.

[Thomas33346017q11r]

What I posted above is exactly what I put inside the simplified field notation. Nothing is in calculation script

[Thomas33346017q11r]

I attached a picture

[try67 · Accepted solution]

OK, then you must switch to using a script, such as this one (note you must also take into account the situation where G30 equals G31, to avoid division by zero):

var G28 = Number(this.getField("G28").valueAsString);
var G29 = Number(this.getField("G29").valueAsString);
var G30 = Number(this.getField("G30").valueAsString);
var G31 = Number(this.getField("G31").valueAsString);

var v1 = (G30-G31);
if (v1==0) event.value = "";
else {
	var v2 = (G30-G28);
	var v3 = G29*(v2/v1);
	event.value = Math.pow(v3, 0.54);
}

[try67]

(I edited the code above to make sure the values are converted to numbers)

[Thomas33346017q11r]

Awesome!! I just need to copy and paste this into my pdf and I'm good to go?

[try67]

Yes, under the "Custom calculation script" option.

[Thomas33346017q11r]

Copy and pasting that does not give me the correct results. Here is the formula i am trying to replicate from the excel spreadsheet. =+G29*((G30-G28)/(G30-G31))^0.54 Maybe looking at the original one will help guide me in the right direction?

[try67]

Can you share the PDF file?

[Thomas33346017q11r]

I shared the link. Its doing some math but not giving me the right results. 

[Thomas33346017q11r]

With the numbers in the spreadsheat now my bottom box in green should show 2,499. 

[try67]

That's incorrect.

(1048*((70-20)/(70-60)))^0.54 = 101.962128972 

[Thomas33346017q11r]

The 1048 should not be included in the power of .54 we need power of 54 on all the math and then it be multiplied by the 1048

[try67 · Accepted solution]

Ah, OK, that makes more sense... Then change these two lines:

var v3 = G29*(v2/v1);
event.value = Math.pow(v3, 0.54);

To:

var v3 = (v2/v1);
event.value = G29*Math.pow(v3, 0.54);

[Thomas33346017q11r]

Hmm I don't see what seems to be the issue I'm not getting the numbers I need. 

[try67]

Works fine for me. See attached.

[Thomas33346017q11r]

I see what I did, I got it to work on my end. Appreciate you taking your time to help and explain!!!!

[Craig233868948lqt]

I just created a fillable PDF form (yesterday) with two very minor formulas using Acrobat Pro, but when you open this PDF in Acrobat Reader (I've also tried another PDF Reader), the math formulas it don't work.  The ADOBE support guy said that the Reader is a free tool so not all the functionality works.  Then what good are formulas in PDF's then?

[try67]

What they told is you blatantly wrong. Every math formula that works in Acrobat should also work in Reader. Only things like extracting pages and stuff like that won't work there.

Did you test it on a mobile device, though, or on a regular PC? Unfortunately, many scripts won't work on the former, regardless of it being Acrobat or Reader.

Third-party viewers are a completely different question. You can't guarantee it will work in them, at all.

[Craig233868948lqt]

I created it on a Mac with the latest version of the O/S, Tahoe version 26.0.1.  In Acrobat Pro, the form looks like this after entering a couple of expenses:  

Notice that the SubTotal is added up from the individuals expenses and the Total is simply the SubTotal + Sales Tax.  Works great!  Now open this in Acrobat Reader and:

Notice that the math does not happen!  Unless someone can tell me what I'm doing wrong!

[try67]

Are you sure that's Reader? Can you post a full-window screenshot?