11 Replies Latest reply on Apr 12, 2017 6:04 AM by pademo57

    Sum Field Not Including All Fields in Total

    pademo57

      I have to laugh because every day that I show my boss the "new" version he keeps asking me to add "just one more thing."

       

      This time I would like the portal to add up all the days that show a checkbox and not the ones that don't have a checkbox.

       

      I put in a field called "Include", made it into a checkbox that has one custom value: "Y"

       

      When I put it into the portal the field which sums the total comes out with the wrong total shown below:

      WrongTotal.PNG

      It should show a total of 100.

      The sum field (Total Course Days) has a calculation of:

      Sum ( Sections::NoOfDays; Sections::chk_Include = "Y" )

       

      What did I do wrong?