Average of addition without zeros

[guiller]

Hi,

I have two categories: cat1 and cat2

I want to calculate the average of (cat1+cat2), without taking into account the lines in which both cat1 and cat2 are null or zero.

Many thanks!

[chris_djih]

have tried something like this: If( cat1+cat <> 0, <your average calculaton>)