Len,
Just to let you and the list know.
I took the easy way out on this one sometimes it is the best.
I created another column for the day value. Put the 1.0 etc in there and
just added them up. This is a pretty static list that is only added to by
the admin person. Additions might at most be once a year or maybe never. So
the day value as a number works well. I just use the primary key to grab the
day and the description values add the day values and display the
description values in the rows and the sum of the day values in the last
cell.
Dan
on 5/24/02 8:02 PM, Len Wright at [EMAIL PROTECTED] wrote:
> 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
Land: 215-799-0192
Mobile: 610-256-2843
FMP, WiTango, EDI,SQL 2000
[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
