[RBASE-L] - RE: Adding a calculation to a report

[Steve Holanov]

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: rbase-l@rbase.com [mailto:rbas...@rbase.com] 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