• Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
    Dedicated community for Japanese speakers
  • 한국 커뮤니티
    Dedicated community for Korean speakers

Help with converting an excel formula into Javascript

Guest
Jul 30, 2019 Jul 30, 2019

Copy link to clipboard

Copied

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

TOPICS
Acrobat SDK and JavaScript , Windows

Views

210

Likes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines

correct answers 1 Correct answer

Community Expert , Jul 30, 2019 Jul 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;

Likes

Translate

Translate
Community Expert ,
Jul 30, 2019 Jul 30, 2019

Copy link to clipboard

Copied

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;

Likes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Guest
Jul 30, 2019 Jul 30, 2019

Copy link to clipboard

Copied

LATEST

Thank so so much! Appreciate your help.

Likes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines