Skip to main content
Participant
August 16, 2023
Answered

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

  • August 16, 2023
  • 1 reply
  • 648 views

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! 

This topic has been closed for replies.
Correct answer try67

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

 

A_B_C  * D_E_F / 100

1 reply

try67
Community Expert
Community Expert
August 16, 2023

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

Participant
August 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

try67
Community Expert
try67Community ExpertCorrect answer
Community Expert
August 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