Copy link to clipboard
Copied
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!
Copy link to clipboard
Copied
Under field G enter the following as the Simplified Field Notation formula (in the Calculate tab):
A_B_C * D_E_F / 100
Copy link to clipboard
Copied
What value is actually being entered in the second field? Is it "0.45"? Is it "45"? Is it "45%"?
Copy link to clipboard
Copied
I want them to be able to add 45, but the calculation in the field to multiply it, I guess like 0.45
Copy link to clipboard
Copied
Under field G enter the following as the Simplified Field Notation formula (in the Calculate tab):
A_B_C * D_E_F / 100
Copy link to clipboard
Copied
Thank you, I knew it had to be simple, but my brain refused to brain! Thanks so much!