Select and avoid nulls at the same time

[#1]

Hi all,

I have a database where the nulls values are set as 99.

When I calculate the average of the satisfaction for example I use this way to avoid nulls values:

Avg ({$-< [Satisfaction]={"99"}>}[Satisfaction])

The problem is when I tried to select the satisfaction of several logistic values (for example YES or NOT use Whatsapp)

I can do this with the following formula:

Avg ({<[WhatsApp Usage]={"YES"}>}[Satisfaccion])

My problem is how can I do this to the same time? This is, obtain the satisfacction of Whatsapp users but without taking into account the Satisfaction null values that are increasing incorretly the average.

Thanks in advance

Regards

Javi

[roger_stone]

Have you tried this:

Avg ({$-< [Satisfaction]={"99"},[WhatsApp Usage]={"YES"}>}[Satisfaction])

[thakkarrahul01]

You can use on expression with both the conditions like :

Avg ({<[WhatsApp Usage]={"YES"},[Satisfaction]-={"99"}>}[Satisfaccion])

[roger_stone]

Or this

Avg ({$< [Satisfaction]-={"99"},[WhatsApp Usage]={"YES"}>}[Satisfaction])

[#5]

This formula is giving me the opposite avoiding 99 and whatsapp