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...
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}...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.