8 Replies Latest reply on Oct 17, 2017 12:09 PM by Bernd Alheit

    Simple calculations on pdf fillable form

    mirza5313 Level 1

      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

      Capture.PNG

       

      I am attaching excel sheet and pdf file for reference.

       

      Thank You in advance!

       

      100*(1+25%)