- lshad24Asked on January 22, 2014 at 10:09 AM
I have a form that requests numerical input from users on several optional fields. At the end, I have a calculation field (Grand Total) that sums all of the numerical fields. For some reason, the Grand Total will not appear unless all of the numerical fields are completed. Can I not just get a running total that sums just the fields the user completes?
The box for Wait for input before including the field in teh caluclation is checked but the calculation field isn't updating correctly.
The form: 40195191793965?
- EliezerNAnswered on January 22, 2014 at 10:47 AM
After some tests with one of my form I undertand what you mean: http://form.jotform.co/form/40206322193847
The total will not show up if the all the fields included in the formula are not filled. However, I think this is due to the way the formula has been built, so please let me work a bit more in the formula in order to find the correct way to make it shows the result even if some of the fields are empty.
I will notify you viat this thread once I found the correct formula.
- lshad24Answered on February 06, 2014 at 05:47 PM
Can you tell me what the status is of this request?
- JotForm SupportWelvinAnswered on February 06, 2014 at 07:02 PM
I've fixed to your form. When using the textbox field, you have to put a default value when you want to "Wait for input before including the field in the calculation", otherwise, uncheck this option.