-
sstte18Asked on November 15, 2018 at 10:38 AM
I can't figure out why this calculation is not working properly. I have tried "is not equal to" value 0 and "does not contain" value 0 in the conditions but once someone enters 0, it zeros out the total.
It's supposed to add $36 * additional # of guests if the total is NOT zero.
Can you help?
Page URL: https://form.jotform.com/82954653856169 -
Welvin Support Team LeadReplied on November 15, 2018 at 12:38 PM
You do not need conditional logic as far as I understand the calculation. You can get the value by calculating fields directly.
1. Add Calculation Value for the field "Would you like to sponsor this event?"
Guide: https://www.jotform.com/help/301-How-to-Assign-Calculation-Value.
2. Get the total by this formula:
Here's a cloned version of your form showing this changes: https://form.jotform.com/83185059982974.
-
Welvin Support Team LeadReplied on November 15, 2018 at 12:41 PM
By the way, make sure to set Clear Hidden Field Values to Clear on Being Hidden in the Form Settings:
This is to correct the calculation once users changes selections.
-
Welvin Support Team LeadReplied on November 15, 2018 at 12:46 PM
I just realized that the calculation may be incorrect. Please clarify how the surcharge of 1.03 is calculated. Is that after getting the sum of "Would you like to sponsor this event?" field and the additional person?
-
sstte18Replied on November 15, 2018 at 1:05 PM
it should be that if they select yes to either sponsorship - it would be 1.03 * (that amount * plus ($36 * number of additional guests). the problem was coming in when the number of additional guests equaled 0. it zeroed everythign out.
if they select "not at this time" then it's just 1.03 * (number of people attending * 36)
-
Richie JotForm SupportReplied on November 15, 2018 at 3:35 PM
You may try to separate each calculation for your total credit and attending guest.
Then combine the total after each calculation,so that you don't need to use conditions.
For total attending:
then you combine the credit with the total attending.
Here is a sample screen cast:
Please give it a try and let us know if you have further questions.
-
sstte18Replied on November 15, 2018 at 8:41 PM
I had to add other conditions to this form so that people could select their method of payment. Do you think this form is working properly? It seems to be but can you review it before I copy over all the conditions to the old form which is live? This is a cloned form...
https://form.jotform.com/83184705420150
-
BJoannaReplied on November 16, 2018 at 3:17 AM
I inspected and tested your form and as far as I can see it is working properly.
I would suggest you to test it a few times more just to be sure.