Average of addition without zeros

guiller — Thu, 10 Feb 2022 12:23:51 GMT

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!

Re: Average of addition without zeros

chris_djih — Mon, 14 Feb 2022 14:47:57 GMT

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