topic Re: Formula excluding values in QlikView

Formula excluding values

danialier — Fri, 18 Jul 2014 09:46:49 GMT

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 — Fri, 18 Jul 2014 09:58:23 GMT

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

let me know

PabloOrtiz — Fri, 18 Jul 2014 10:00:11 GMT

Hi dani, try this:

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