Hello PChandima,

You will have to create your own formula fields to calculate the statistics.

MySum:(in detail line)

Global numbervar vSum;

Global numbervar vCount;

if A<>0 then

(vSum := vsum + A

vcount := vcCount +1

)

Then where you want the average:

MyAvg:

Evaluateafter(Mysum);

Global numbervar vSum;

Global numbervar vCount;

If vCount <>0 then

vsum/vcount

else

0

Minimum also needs to use a formula:

MyMin: (in detail line)

numbervar vMin;

if A<>0 and A<vMin then

vMin := A

else

vMin:= vMin;

vMin

Pete

You will have to create your own formula fields to calculate the statistics.

MySum:(in detail line)

Global numbervar vSum;

Global numbervar vCount;

if A<>0 then

(vSum := vsum + A

vcount := vcCount +1

)

Then where you want the average:

MyAvg:

Evaluateafter(Mysum);

Global numbervar vSum;

Global numbervar vCount;

If vCount <>0 then

vsum/vcount

else

0

Minimum also needs to use a formula:

MyMin: (in detail line)

numbervar vMin;

if A<>0 and A<vMin then

vMin := A

else

vMin:= vMin;

vMin

Pete