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?
=round((sum(cint(Fields!ows_Missing_Medical.Value)) / count(Fields!ows_Missing_Medical.Value)) *100) & "%"