Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2004
    Posts
    11

    Question Unanswered: Urgent....Getting Total...Plzzzzzz help me...

    Hi All,
    I am selecting Maximum of utilization fom one column from a database table,on per day basis.(i.e. for single day it will select maximum,then for other day it will select other maximum,and so on).
    Now,I want to add all these selected maximum values and also count the value of number of there Maximums.
    Is there anyway to Add all these selected Maximums ?
    And to get average of these values ?
    Thanks in advance,
    Chandresh .... I am

  2. #2
    Join Date
    Nov 2004
    Posts
    5
    Sum(Fields!TOTAL1.Value, "DataSet1") + Sum(Fields!TOTAL2.Value, "DataSet1") + ..
    (put this in textbox to display)

    TOTAL1 and TOTAL2 is your MAX value that you have now, depending on which DataSet you want the value to come from

    I'm not sure about the Average, sorry.

    Hope these help

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •