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
-----
Try using the following expression in Col3, Col4, Col5
Total([column] for Report) / Total( if ([column] <> 0) Then (1) else (0))
or
use average(if col = 0 then NULL else col end)