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

I need to take the value entered into one field and multiply it by the % value entered in another

Community Beginner ,
Aug 16, 2023 Aug 16, 2023

Hi there, I'm working on a form, and I'm trying to figure out how to write a custom calculation script for the following:

$ amount entered into field “All Be Cool” x amount entered into field “Do Everything Fun %”

Ex. enter $5000 in A_B_C field then enter 45% in D_E_F, =  total in field G

$5000 x 45% = $2,250

ABC x DEF = G

 

I think the rest should be easier because I just need to subtract and add in all the others. 

 

Thanks so much! 

TOPICS
Edit and convert PDFs , How to , JavaScript , PDF , PDF forms
525
Translate
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
1 ACCEPTED SOLUTION
Community Expert ,
Aug 16, 2023 Aug 16, 2023

Under field G enter the following as the Simplified Field Notation formula (in the Calculate tab):

 

A_B_C  * D_E_F / 100

View solution in original post

Translate
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
Community Expert ,
Aug 16, 2023 Aug 16, 2023

What value is actually being entered in the second field? Is it "0.45"? Is it "45"? Is it "45%"?

Translate
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
Community Beginner ,
Aug 16, 2023 Aug 16, 2023

I want them to be able to add 45, but the calculation in the field to multiply it, I guess like 0.45

Translate
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
Community Expert ,
Aug 16, 2023 Aug 16, 2023

Under field G enter the following as the Simplified Field Notation formula (in the Calculate tab):

 

A_B_C  * D_E_F / 100

Translate
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
Community Beginner ,
Aug 16, 2023 Aug 16, 2023
LATEST

Thank you, I knew it had to be simple, but my brain refused to brain! Thanks so much! 

Translate
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