Problem with calculation

  • Profile Image
    beatsahead
    Asked on January 12, 2016 at 08: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.

  • Profile Image
    Jeanette
    Answered 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.

  • Profile Image
    beatsahead
    Answered on January 12, 2016 at 03: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.

  • Profile Image
    beatsahead
    Answered on January 12, 2016 at 04:16 PM

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

  • Profile Image
    Jeanette
    Answered on January 12, 2016 at 04:18 PM

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

    Cheers!