betto
May 18th, 2000, 10:52 PM
I hope you can understand me with this.....
I made a crytal report which has three columns.
I want the third col showw me Average frm the secon col,
but record by record from the begin.. for example:
DATE AMOUNT AVERAGE
date1 Item1 Average(Item(1))
date2 Item2 Average(Item(1,2))
date3 Item3 Average(Item(1,2,3))
I tried with a formula: Average({File.Amount})
but it always shows me total average from the
second col, like this:
DATE AMOUNT AVERAGE
date1 Item1 Average(Item(1,2,3))
date2 Item2 Average(Item(1,2,3))
date3 Item3 Average(Item(1,2,3))
Does anyone know a formula to do i want?? i meant the first array..
id really appreciate it...
betto :)
betto@mail.com
I made a crytal report which has three columns.
I want the third col showw me Average frm the secon col,
but record by record from the begin.. for example:
DATE AMOUNT AVERAGE
date1 Item1 Average(Item(1))
date2 Item2 Average(Item(1,2))
date3 Item3 Average(Item(1,2,3))
I tried with a formula: Average({File.Amount})
but it always shows me total average from the
second col, like this:
DATE AMOUNT AVERAGE
date1 Item1 Average(Item(1,2,3))
date2 Item2 Average(Item(1,2,3))
date3 Item3 Average(Item(1,2,3))
Does anyone know a formula to do i want?? i meant the first array..
id really appreciate it...
betto :)
betto@mail.com