Calculating Percentage of Checked Boxes on a Sharepoint List

I have a SharePoint list that has several columns of the Yes/No datatype.  I am feeding the info from this list into Visual Studio and trying to figure out how to calculate the percentage of the boxes that are checked in a certain column.  I have a formula that is calculating a number but that number is always wrong.  I am not really sure what to do in this case.  You'd think Microsoft would have made this a little easier... surely I am not the only one that has ever wanted to do this?
Thanks!
=round((sum(cint(Fields!ows_Missing_Medical.Value)) / count(Fields!ows_Missing_Medical.Value)) *100) & "%"

Open in new window

LVL 1
wyldtwystAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

AndornagyCommented:
How did you feed the list to the Visual Studio? Where did you want to display this information. I suggest to use CAML query against the list.
0
wyldtwystAuthor Commented:
I fed the list into Visual Studio with a long, convoluted process that Microsoft really should improve considering Sharepoint and Visual Studio are both Microsoft products.
Anyways, the better question for me to ask is probably this:
How do I count all of a field where the value is equal to a parameter?  for example:

count(Fields!ows_Month_submitted    -- and then I want to say WHERE Fields!ows_Month_submitted.Value = Parameters!Month.Value

It must be so easy, I just can't figure it out!
Thanks!
0
AndornagyCommented:
It's looks like Youa are in the reportviewer control. I'm not really good in reportviewer. I didn't decide that You have problem with getting data from sharepoint or creating visual report from a dataset.
0
Cloud Class® Course: Ruby Fundamentals

This course will introduce you to Ruby, as well as teach you about classes, methods, variables, data structures, loops, enumerable methods, and finishing touches.

wyldtwystAuthor Commented:
Yes sorry, perhaps I should have mentioned that!  I am building a report.  Sorry minor detail, eh? =)
0
AndornagyCommented:
If you can't deal with reportviewer try to precalculate data from query and pass to report via parameters.
Or you can take ideas from gotreportviewer site: http://www.gotreportviewer.com/
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
wyldtwystAuthor Commented:
Hmmm.. I skimmed over the site but I don't see anything that would help... Sharepoint already has a report viewer web part so that's taken care of and I don't see any specifics on how to add conditions.  Thanks for the link though.


This has to be super-easy!  >.< It's driving me nuts!
0
wyldtwystAuthor Commented:
I think I am going to re-ask my question and give you points for the effort =)
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
.NET Programming

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.