OK, what I would do, is have a group based on date, or sorted on date in the order that you want.
Then I would have a formula with some shared variables, something like:
shared numbervar iCount;
shared numbervar iSum;
if iCount < 3 then (
iSum := iSum + {table.field};
iCount := iCount + 1;
)
""//hide the formula
in the group header you will need a reset, like:
shared numbervar iCount:=0;
shared numbervar iSum := 0;
""
where you want the average, the formula would be like:
shared numbervar iSum;
iSum/3
HTH
IP Logged
