baseportal
Start

baseportal message board

Welcome to the baseportal message board...

Please read the FAQ.

 
 Selected message: To the list 
    Message from Claus on 3/23 2012, 16:36 +01:00

    Re: Calculating Sum


      How can I calculate the sum of a column?

          Assuming that the database contains the field "Points", use the following code for the total number of points:

          Total: <loop code=perl>$Total+$Points</loop>


      hth

      Greetings

      Claus

    Your reply:

    Name: EMail: WWW:
    Subject:
    Text:
    Timezone:

    Post a new message


 All messages from this thread: To the list 
    Message from mbel on 3/19 2012, 06:29 +00:00
    EMail: mbel@cox.net

    Calculating Sum


      How can I calculate the sum of a column for specific condition? For example, I have a text field: "Comittee", a number field: "Number of Volunteers", and checkboxes: "January 10" and "January 11". I would like to sum up the values in "Number of Volunteers" each Committee has entered for January 10. In other words, add up all the values entered in "Number of Volunteers" for January 10. How do I do this?
     Post a reply

    Message from Claus on 3/23 2012, 16:36 +01:00

    Re: Calculating Sum


      How can I calculate the sum of a column?

          Assuming that the database contains the field "Points", use the following code for the total number of points:

          Total: <loop code=perl>$Total+$Points</loop>


      hth

      Greetings

      Claus

     Post a reply



    Message from Claus on 3/24 2012, 06:50 +01:00

    Re: Calculating Sum


      It seems, there are some Mistakes in FAQ...;)

      <loop db=yourdatabase Date==$Date code=perl>
      $Total+=$Points
      </loop>
      Total: $Total

      hth

      Claus

     Post a reply
     
 Newest 150 Threads: To the input form 
To the input form | Older messages > | Oldest messages >>


Back to the homepage

© baseportal.com. All rights reserved. Terms of use



powered in 0.06s by baseportal.com
Get your own Web Database - for FREE!