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

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!

このトピックへの返信は締め切られました。

解決に役立った回答 try67

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

A_B_C * D_E_F / 100

Community Expert

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

Participant

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

Participant

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

A_B_C * D_E_F / 100

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

サインアップ