Skip to main content
A
Anonymous
July 30, 2019
Answered

Help with converting an excel formula into Javascript

  • July 30, 2019
  • 1 reply
  • 695 views

I am trying to convert an Excel expression/formcalc script that essentially divides the totals of two fields provided on a PDF form. One field may include a total entered on a another page.  The formcalc script I am currently using works, and is listed below.  Is there any chance someone might be able to help me with converting to javascript?  Thanks so much!

if(Page1.Total_undupl ne 0 & HasValue(Page1.Total_undupl)) then

Total_al_instr / Page1.Total_undupl

else

null

endif

This topic has been closed for replies.
Correct answer try67

You can use something like this:

var v1 = Number(this.getField("Total_al_instr").valueAsString);
var v2 = Number(this.getField("Page1.Total_undupl").valueAsString);
if (v2==0) event.value = "";
else event.value = v1/v2;

1 reply

try67
Community Expert
try67Community ExpertCorrect answer
Community Expert
July 30, 2019

You can use something like this:

var v1 = Number(this.getField("Total_al_instr").valueAsString);
var v2 = Number(this.getField("Page1.Total_undupl").valueAsString);
if (v2==0) event.value = "";
else event.value = v1/v2;
A
Anonymous
July 31, 2019

Thank so so much! Appreciate your help.

Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices