I need one column in my Datatable to calculate a percentage for each row. This percentage will show the number of cells in the each row that meet a specification. For example: What percentage of cells in each row are greater than 5?

First, I need to count all of the cells in each row that aren't blank. Then I need to count all of the cells that are greater than 5. Then I need to divide the number of cells that are greater than 5 by the number of cells that aren't blank and this will provide me with my percentage.

What columns does your table have? Are there null values, which type do they have? It would be easier if you could show at least a sample table, best by providing the population code.
–
Tim SchmelterFeb 22 '13 at 19:40