SELECT ((SUM(CALLSHET.TOTMNHRS FROM Memberbasics))/60) WHERE... You needed parenthesis around the entire expression
Dennis McGrath ________________________________ From: [email protected] [mailto:[email protected]] On Behalf Of Steve Holanov Sent: Saturday, January 31, 2009 1:32 PM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: Adding a calculation to a report 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<mailto:[email protected]> To: RBASE-L Mailing List<mailto:[email protected]> 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]> [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
