Steve,
When defining the variable in your report use the following syntax:
varname DOUBLE = (SUM(TOTMNHRS)/60) IN +
CALLSHET WHERE whereclause
Also, the syntax for your SELECT statement is incorrect. Try the following:
SELECT (SUM(TOTMNHRS)/60) FROM
CALLSHET.
Jim Bentley
American Celiac Society
_filtered #yiv1992252816 {
font-family:Cambria Math;}
_filtered #yiv1992252816 {
font-family:Calibri;}
_filtered #yiv1992252816 {
font-family:Tahoma;}
_filtered #yiv1992252816 {margin:1.0in 1.0in 1.0in 1.0in;}
#yiv1992252816 P.MsoNormal {
FONT-SIZE:12pt;MARGIN:0in 0in 0pt;FONT-FAMILY:"Times New Roman", "serif";}
#yiv1992252816 LI.MsoNormal {
FONT-SIZE:12pt;MARGIN:0in 0in 0pt;FONT-FAMILY:"Times New Roman", "serif";}
#yiv1992252816 DIV.MsoNormal {
FONT-SIZE:12pt;MARGIN:0in 0in 0pt;FONT-FAMILY:"Times New Roman", "serif";}
#yiv1992252816 A:link {
COLOR:blue;TEXT-DECORATION:underline;}
#yiv1992252816 SPAN.MsoHyperlink {
COLOR:blue;TEXT-DECORATION:underline;}
#yiv1992252816 A:visited {
COLOR:purple;TEXT-DECORATION:underline;}
#yiv1992252816 SPAN.MsoHyperlinkFollowed {
COLOR:purple;TEXT-DECORATION:underline;}
#yiv1992252816 SPAN.EmailStyle17 {
FONT-WEIGHT:normal;COLOR:#1f497d;FONT-STYLE:normal;FONT-FAMILY:"Times New
Roman", "serif";}
#yiv1992252816 .MsoChpDefault {
FONT-SIZE:10pt;}
#yiv1992252816 DIV.Section1 {
}
Buddy:
I did look at DB Calc but there were very few
options for calculations, mainly a few built items such as Sum and
Count.
Here is my proposed SQL:
SELECT (SUM(CALLSHET.TOTMNHRS FROM
Memberbasics))/60
where TOTMNHRS is my column that is totaled
(actually minutes per row)
CALLSHET is the table
I need to divide the TOTMNHRS by 60 to get
hours since the data is actually in minutes.
Thanks,
Steve
----- Original Message -----
From:
Walker, Buddy
To: RBASE-L Mailing List
Sent: Saturday, January 31, 2009 1:57
PM
Subject: [RBASE-L] - RE: Adding a
calculation to a report
Steve
Have
you looked at DB Calc. If you post your SQL statement it would help with
answers or suggestions.
Buddy
From: [email protected]
[mailto:[email protected]] On Behalf Of Steve Holanov
Sent:
Saturday, January 31, 2009 1:45 PM
To: RBASE-L Mailing
List
Subject: [RBASE-L] - Adding a calculation to a
report
I have two
questions about adding a calculation to a report:
1. When I create a
new variable how do I add it to the report form? Either in a header/footer or
preferably at the end of the table data in the report
body?
2. I can easily
define the calculation I want in SQL but cannot get the expression builder to
accept my SQL string. Any tips for this would be
appreciated.
Thanks in
advance,
Steve
Holanov
Shrewsbury First
Aid Squad
Shrewsbury, NJ
07702
