4 Replies Latest reply: May 7, 2018 4:38 AM by celine xu RSS

    KPI min () and avg() avoid '0' items, count() how many of the items having '0´value

    celine xu

      Hi,

      I am creating KPI using avg( ) or min()

      want to exclude the item have 0 in it. Could I do it? or I have to change 0 to  NULL then do it?

       

      and Also want to also have another KPI show number of t within column do not have 0 value,'

      if (A!=0, count(district t) )

      how could I wright the funtion?

       

      any suggestion ? Thank you!