Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. JohnnyBlack

    Cannot sum calculated and subsequent fiels

    The problem is in the following step, the dailychange is working fine. Since I cannot calculate the avg using the AVERAGE function I add all the detail records of @dailychange and then calculate the an average using count which the number of records (detail level, see columns below). So in the...
  2. JohnnyBlack

    Cannot sum calculated and subsequent fiels

    I got the running total @dailychnage_rt= whileprintingrecords; numbervar x := x + {@dailychange}; and the display total @dailychnage_sum = //{@display}: whileprintingrecords; numbervar x; From here I added an average @dailychange_avg= whileprintingrecords; numbervar y:={@dailychange_sum}...
  3. JohnnyBlack

    Cannot sum calculated and subsequent fiels

    Thank you for the reply. I assume if I use varaibles to get the prev val I will at least be able to calc the avg since this is the basis of the std dev formula. I pretty much have the steps to calulate the std dev manually but have no idea how to use the variables to get the previous value. If...
  4. JohnnyBlack

    Cannot sum calculated and subsequent fiels

    In crystal reports 11, I need to calculate the change between records and use the result elsewhere, but the field does not list the summary function in the shortcut menu and if I create a formula I get the "this field cannot be summarised" error" My dataset is a list of rates at various dates...

Part and Inventory Search

Back
Top