One of my Calculated fiels duplicate when totalling

  • Profile Image
    Asked on December 31, 2016 at 12:19 PM


    At the bottom of the form there are 3 "Total" boxes. Total Distance Total Discount and Total Due.  I cannot get the Total discount box to calculate correctly.  If a selection is made in Total discount and it shows in the Total Discount box the Total Due doubles that amount.   If I disable the calculated fields then the amount is correct in Total Due but the total discount amount does not appear in the Total Discount box.   Where have I gone wrong?  

  • Profile Image
    Answered on December 31, 2016 at 11:32 PM

    We'll check your calculation and get back to you with a solution.

    Stay tuned!

  • Profile Image
    Answered on December 31, 2016 at 11:55 PM

    I cloned your form and I was able to resolve it using a single condition.

    Please clone this form so you can use it as well as figure out the setup.


    Basically, I used form calculation fields on 3 totals and added a new total field to get the Total AERC from the NON AERC Member checkbox. I also assigned calculation value on every checkbox.

    If you have further questions, let us know.