Problem with calculation

  • beatsahead
    Asked on January 12, 2016 at 8:46 AM

    My total_no has a calculation that is performed and is dependent on the amount in lenght_of and the DJ radio selection, however as you move between the radio selections the number is not recalculated which is causing me to have bookings at the wrong rate.

  • Jeanette JotForm Support
    Replied on January 12, 2016 at 12:48 PM

    I see that  total_no is not only dependent on those two fields, but another hidden field "Peak" which also dependent on other calculations.

    One thing that I notice is that you have set IF "All"  of the "IF" rules are matched for this field, which makes the field to update only when ALL the conditions are met, thus, ignoring the rest of the conditions, which is what causes the conflict so I would suggest to change it to IF "Any" , or explain better how the scenario is so we can further help you.

    Problem with calculation Image 1 Screenshot 20

  • beatsahead
    Replied on January 12, 2016 at 3:29 PM

    All the conditions would need to be met, to get the correct calculation in the field.

    The calculation is being done correctly initially then when the length is changed the amount changes (as it should) but if the DJ is also changed after this the amount stays the same, unless the length is altered again.

  • beatsahead
    Replied on January 12, 2016 at 4:16 PM

    Thanks for your help, I worked it out. I needed ALL conditions for everything pertaining to the calculation

  • Jeanette JotForm Support
    Replied on January 12, 2016 at 4:18 PM

    Glad to hear you managed to solve the issue by fixing the conditions in conflict.

    Cheers!