Count (sum)of Check Box's 1

[kentwoodjean]

I looked at about 30 different pages in the forum and cannot find the answer. I am sure it is fairly simple but I just can't seem to find the right combination. I have a report that totals by month several different categorie. With the exception of the check box, I use show "=Sum([General]) with the appropriate category name. Since the check box defaults to "Yes", I showed =Sum([Worksheet]) and I get a negative #, like -15 to represent a total of 15 checked boxes. How do I show this in a postivie state? Below are my Fields.

General
Clean Claims
Misdirected
PA250
DOL
Yes (to "worksheet" field represented by a check box)

 

[PaulBricker]

Use
=Abs(Sum(Worksheet))

Paul

 

[kentwoodjean]

Thanks Paul, So simple but without understanding Abs, I would never have gotten it. I looked Abs up on help and now understand how that works. As always, you are a great resource.

Perhaps, you could take a look at another thread I have out there. It is #703-506662 on Formating & Summaries. Randy replied and pointed me to an FAQ that I read and tried but it didn't work right as you can see in my reply back to Randy. I have had no further contact with him. Can you lead me in the right direction? This is the only thing holding me up from completing another project.