-
I know that this subject belong to Database Development
thats what i apologize with you but i really need an answer...
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 :)
[email protected]
-
What version of Crystal are you using? If you are using version 6 or above ( I think ) you can use a Running Total;
1. Click on INSERT / RUNNING TOTAL
2. Click NEW
3. Enter a name for your total (eg Running Average)
4. Select the field you want to average and click on the [>] button to place it in the "Field to summarize" box. Then select "Average" from the "Type of Summary" box.
5. Leave "Evaluate" on "For Each Record", and "Reset" on "Never"
6. Click on OK and you can then drag the running total field onto your report next to the field you want to average.
-
Oh im sorry i forgot.. it's CRW32 v 4.6
..no it doesn't have it...
-
I suggest you get CR 6. You can download it for free from Seagate.
