I need to know how to do calculations based off multiple fields and then have the result display in a results filed.
I found this thread talking about it but, it seems like it should be easier than this, am I wrong?
http://www.gravityhelp.com/forums/topic/loan-calculator
The calculations are very simple>
(a+b)
(b-c)
(a/c)
(c*b)
Can I get a little direction on this please?
Shawn
rcDev
Member
Shawn,
You should be able to use a number field to achieve this. Number fields support formulas using BEDMAS math and merge fields. Just insert a new number field, "Enable Calculation" and you should be able to figure out the rest.
-Mark
Mark,
Thank you.
Just to expand/clarify I want to take input from a user and apply them to a formula and than show the result. Here is what I'm sure I can do now.
Number Field == calculate the formula & take imput.
What I'm curious of is can I take input from other fields and use them in the calculations. Is there a special way to "call" the inputs?
Would the formula look something like this?
=Sum(field Id 1 * field Id 3)
Thx
Shawn
Yes, you would use merge tags to do this. With the calculation section, there is a drop down that allows you to pick and choose what fields you want.
Sorry for the dumb question.
To anyone else trying to figure this out it really is as straight forward as it seems that it should be.
If you start with a Number Field and fill in the Field name when you go to do your calculation the name is in the dropdown for doing calculations.
Glad you were able to figure it out. All my best!
