don't calculate zero value

[mc09]

hi 
how can i implement below
table A
col1 col2 col3 col4 col5
1     AA   10    10   10
2     AA    20   10    0
3     AA    0     10    0
i want to this show report as
col2  col3  col4  col5
AA    15    10     10
-----

[Gopinath]

Try using the following expression in Col3, Col4, Col5


Total([column] for Report) / Total( if ([column] <> 0) Then (1) else (0))

[uttam.mistry]

or
use average(if col = 0 then NULL else col end)