Hi Dan,
you could create a
"Custom Column" under the "Select Columns:" in the search
action. (by right-clicking)
(SUBSTRING(Compensation.Compensation_Description,1,(LOCATE(Compensation.Compensation_Description,'
',1)))) as Days
then just
<@CALC
EXPR="SUM(@@local$sumhours[*,Days])">
you might need to check the
built in functions for SQL but I can do this in Sybase
But I still think it would be easier to
just include the Days column (if you have it stored separately) ;-)
-----Original Message-----
From:
[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Dan Stein
Sent: Wednesday, May
22, 2002 12:31 PM
To: Multiple recipients of list
witango-talk
Subject: Witango-Talk: MetaTag
syntax question
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="#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=""#""
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
