How about just start by doing a display of the array's resultset and see
what you get. Maybe you have a string character someone that is
preventing the math
>>> [EMAIL PROTECTED] 05/22/02 12:30PM >>>
I have a resultset that in one row returns data like this
1.0 Day trade In
1.5 Day trade in
In the last row of the table that shows this data I want to sum the
hours so
I want to add just the numbers. I have no problem with the Calc for the
sum
of the hours but can�t figure out how to do a sum for the numbers in
the
last column that has mixed text and numbers. I tried some things with
the
<@Keep> tag but it seems its not allowed with the Sum.
</HEAD>
<BODY>
<@ASSIGN NAME="local$sumhours" VALUE="@@resultset" >
<table width="100%" border="1">
<tr bgcolor=Received: from PCS-MTA by plusinternational.co3D"#3333FF">
<td colspan="4" align=center><font color="#FFFFFF"><B> Dates and
Times
and
Compensation for <@COLUMN 'Courses.Title'></B></font></td>
</tr>
<tr bgcolor="#CCCCCC">
<td>Date</td>
<td>Time</td>
<td>Act 48 Hours</td>
<td>Compensation</td>
</tr>
<@ROWS>
<tr bgcolor="#CCCCCC">
<td><@COLUMN 'Course_CrossLink.Course_Date' FORMAT='Datetime:%A, %B
%d,
%Y'></td>
<td><@COLUMN 'Course_Times.Course_Time'></td>
<td><@COLUMN 'Course_CrossLink.Act48Hours'></td>
<td><@COLUMN 'Compensation.Compensation_Description'></td>
</tr>
</@ROWS>
<tr bgcolor="#CCCCCC">
<td></td>
<td>Total Hours</td>
<td><@CALC EXPR="SUM(@@local$sumhours[*,8])"></td>
<td>(this is where the sum of compensation will go)</td>
</tr>
</table>
<p><A HREF="#" onclick="javascript:window.close();">Close
Widow</A></p>
--
Dan Stein
Digital Software Solutions
799 Evergreen Circle
Telford PA 18969
215-799-0192
610-256-2843
Fax 413-410-9682
FMP,Tango, EDI,SQL 7
[EMAIL PROTECTED]
www.dss-db.com
________________________________________________________________________
TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED]
with unsubscribe witango-talk in the message body
