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

    Sum Field Not Including All Fields in Total


      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:


      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?