weird behaviour on condition wizard add field calculation

  • Profile Image
    Asked on March 02, 2015 at 04:55 PM

    Here is what I am trying to do I am seeing weird values. I have check box and total field. When Check box is selected I am trying add 15 (number) to total.  The way I tried to do is using Add field option. But instead of 15 I am seeing 150. This is super simple calculation and frustration not to accomplish such simple task.

    please help.

  • Profile Image
    Answered on March 02, 2015 at 06:18 PM


    Rather than using the conditions, I would recommend using the calculation widget.  This will allow you to assign calculation values to your checkboxes and then forward those values to the widget:

    You had already added calculation values to a few of your fields:

    You would need to add a value to each one of you fields.

    After that, using the calculation widget, you can simply add up all the fields:

    I also need to remove all the conditions you were using to try to do the calculation.  You don't need to insert the values, the calculation widget will add up their associated calculation values.

    Here is my test form to show you how it works:

    For most of the fields I just entered 15 for the calculation value.  You can set the value to whatever you'd like.  For instance, you'll notice when "Grup J : Dugun pastasi (WEDDINGS CAKE)" is selected, it adds 50 to the total.

    I hope I made things a bit more clear.  Let us know if you have any further questions and we will be happy to help.

  • Profile Image
    Answered on March 02, 2015 at 08:15 PM

    Thanks for the quick respond. I can use the calculation widget but I have to use the condition. Because I only want to add them in to total when they are selected. Please advice.

  • Profile Image
    Answered on March 03, 2015 at 12:00 AM

    Hello alpgulden,

    The solution suggested by my colleague will work best for you. The amount will not be added in total if they are not selected.

    If you add conditions to add total, it will further complicate your conditions. You will have to add several condition to insert values based on the selection.

    Do get back to us if you still want to use the conditions, we will do the needful in a cloned form.

    We will wait for your response.

    Thank you!