Formula excluding values

[danialier]

Hi,

I want a formula that gives me the average revenue for company A excluding the cells with "0" and "n/a" values. Formula below is not working...

=avg({<[Revenues Customer A]<>'0'+'n/a'>}[Revenues Customer A])

Could you please help ?

thks,dani

[alexandros17]

avg({$ <[Revenues Customer A] = {[Revenues Customer A]} - {'0', 'n/a'}>}[Revenues Customer A])

let me know

[PabloOrtiz · Accepted solution]

Hi dani, try this:

=avg({<[Revenues Customer A]-= {'0','n/a'}>}[Revenues Customer A])