4 Replies Latest reply: Aug 17, 2015 3:54 AM by arjun rao RSS

    Is RowNo function skipping first value by default?

    John Blomqvist

      Hi all,


      I have the following table:




          Num($(vMin)+ RowNo()-1) as Numbers1


          $(vMax) - $(vMin)+1;


      This table generates all possible numbers from 1 to 100.


      I've noticed that if I don't insert a -1 after RowNo() function above it starts from number 2.


      And I have to do a +1 in order to get the last value.


      Is it because RowNo() is by default gives you the next row rather than the first row value?