8 Replies Latest reply: Aug 29, 2017 3:04 AM by Staffan Johansson RSS

    Previous first row

    Staffan Johansson

      Hi,

       

      I have a problem building a flag in script. I have use previous and get a correct output, expect first row.

      Here is my table.and this is for changeflag if(previous(dimension)=dimension  ,0,1)

      What I want is to get a 1 on the first row With a New Dimension. I think that the first 1 will be there because previous find null and compare it With the first row.

      Any trix to avoid this scenario?