arsaaved

Hello. I have a slight problem. I am trying to take the following values from a table.

<% if rs("wip") >0 then %>
<td align="middle" nowrap>
<small>
&nbsp;
<%= rs("wip")%>/<%= rs1("wordphrase")%>
&nbsp;&nbsp;
<font color=blue>
<%=round( rs("wip")/rs1("wordphrase")*100)%>%
</font>
</small>
</td>
<% else %>
<td align="middle" nowrap>
<small>
&nbsp;n/a&nbsp;&nbsp;
<font color=blue>
</font>
</small>
</td>
<% end if %>

The part in orange is what I need to sum then divide by the count of the rows displayed. I've done stuff that works for other parts server side, the problem is that the data in the "wip"/"wordphrase" can change year to year. These are test results.

For example a wordphrase taken in 2000 might contain 6 total questions
but in 2001 wordphrase might contain 8 total questions
either way 3/6 and 4/8 are still 50%, but I can't rely on counting the possible questions right-to-total questions because each year the data changes. This is why I'm trying to figure out how to capture the round( rs("wip")/rs1("wordphrase")*100) data that is displayed and then add those up and divide by the total rows for that data that are displayed.

If there's a way to do it serverside I'd rather do that, but for now clientside will be good enough. If you can at least point me in the right direction so that I can then understand this better I would greatly appreciate it, because later I have to further separate it by gender and race. Thanks.

2bNvUs

Is it giving you error messages or just the wrong answer to your equation?

xamua

if you're handy with SQL you could probably do the sum(s) right in your database when you query it for your data...if i could see the SQL you're using now to pull the data out i could likely be more specific.