7 Replies Latest reply: Nov 12, 2012 3:33 AM by Anita Fuchten RSS

    Need rownr in 2nd expression

    Anita Fuchten

      The table below is what I show.

       

      table.png

       

      The grey values are expressions, the white ones are the dimensions.

       

      In the field count I need a number which counts up from 1, 2, 3, 4, 5, .. .etc (just from first to last row)

       

      I tried the function RowNo():

      table2.png

       

       

      And the function RowNo(TOTAL)

      table3.png


       

      The RowNo(TOTAL) looks somehow what I need, but I only need the rows with a value.

      When saying that to the count column it shows the numbers 3, 5, 6 . . . instead of 1, 2, 3

       

      Anyone knows how to handle this?? I just need some numbering for an export.

       

      thx in advance,

       

      Anita