- businetAsked on May 17, 2014 at 10:33 PM
- JotForm SupportWelvinAnswered on May 18, 2014 at 06:41 AM
The calculation feature is moved as a Widget to our widgets section. Please check this guide: https://www.jotform.com/help/259-How-to-perform-calculation-in-the-form
Let me also add that if you have a field, for example, a dropdown field, each option can have a calculation values. You just need to set it into the field properties. Please check this screenshot:
Settings > Show Properties > Calculate Values:
This feature in each field is useful if you want to hide the prices and just show the text options.
Also check this related guides for calculation:
Hope that helps. Let us know if you have any further questions.
- JotForm SupportWelvinAnswered on May 18, 2014 at 11:06 AM
This thread is currently marked as not-answered, but we do not receive your reply. Please access this thread and respond from here instead: http://www.jotform.com/answers/378913.
- businetAnswered on May 18, 2014 at 03:36 PM
Thanks but all I am looking for is a simple 'Sum' function. I do not think it is in the list?
- JotForm SupportjonathanAnswered on May 18, 2014 at 06:02 PM
Hi, you meant the "Sum function" was not available in the Math Function Reference right?
To have SUM() using the Calculation widget, you just use addition function.
Basic math operators like (add, multiply, division and subtraction) were already available. I think most of those listed in the math reference were advance math functions instead.
Hope this help. Please inform us if you have further question.
- businetAnswered on May 18, 2014 at 06:07 PM
Thanks I have used this function. But I have 18 different questions. It would have been easier if I just put in 'sum(Q1.Q18)'. The Sum function is a standard mathematical function available say in Excel but not the JotForm Math Function Reference. i just find this strange when there are many other, often not used, functions there.
- BryanPauloAnswered on May 18, 2014 at 06:29 PM
The Sum function of excel won't work perfectly for forms unlike spreadsheets. Spreadsheet cells has a constant cell address which you can reference to sum up their values. Forms on the other hand are fields of different types and their labels vary from time to time.
Should you wish to use a spreadsheet to calculate values, you may wanna consider using the Spreadsheet widget which can use formulas to calculate the values.