AnsweredAssumed Answered

Sum Field Not Including All Fields in Total

Question asked by pademo57 on Apr 11, 2017
Latest reply on Apr 12, 2017 by 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?

Outcomes