10 Replies Latest reply: Jan 2, 2018 8:55 PM by Eaphy Mao RSS

    Set Analysis > 0 in KPI

    Eaphy Mao

      I'm trying to get a KPI to show a the last year/week where I have positive inventory. The underlying data set looks like the below. I'm trying to get a max yearweek with the set inventory greater than 0. Is this possible, what syntax would I use? Really appreciate any help.

       

      YearWeekInventory
      2018011
      2018022
      2018033
      2018040