Skip to main content
mirza5313
Known Participant
October 17, 2017
解決済み

Simple calculations on pdf fillable form

  • October 17, 2017
  • 返信数 1.
  • 3548 ビュー

I have an excel spreadsheet which contains simple calculations but it seems not working on pdf fillable form with custom calculation script?

can anybody help me to get rid of this issue?

Actually, I am doing this calculation on a filed but don't know to achieve this figure result in field

100*(1+25%)

So, 25% field can be read-only or not visible but this will not calculate the result of 125?

Here is the code I am using:

// Get first field value

var v1 = getField("pay rate").value;

// Get second field value

var v2 = getField("Text2").value;

// Set this field value equal to the difference

event.value = v1 * v2;

I am hiding 25% filed as this will remain same and do not need to show.

Here are excel sheet and pdf form

I am attaching excel sheet and pdf file for reference.

Thank You in advance!

100*(1+25%)
このトピックへの返信は締め切られました。
解決に役立った回答 Bernd Alheit

Thanks, It's working, Now there is a little problem on second fields of Margin $ which is also multiplied by two fields but one of them is % figure so if I multiply both fields:

125*50%= I got 6250 instead of 62.5?


Divide the value by 100.

返信数 1

Inspiring
October 17, 2017

25% is 0.25 decimal value.

mirza5313
mirza5313作成者
Known Participant
October 17, 2017
Yes but I want this =500*125% and 500 is input figure means the user can enter any other figure.
So when I go to Simplified field and enter field name * 0.25 result is not correct