1 Reply Latest reply: May 15, 2014 10:03 AM by Data Kruncher RSS

    Incrementing Field

    trsutton _

      Hi - does anyone know how to add a field that is numeric and increments from a given start sequence.  I am looking for something similar to the fill option in excel.

        • Incrementing Field
          Data Kruncher

          Use a formula-based or runtime parameter calculated field for your initial value, then use another formula-based calculated field to add the table row number to the initial value, like this:

          InitVal+Rowno()[/code]Note that you cannot use Rowno() in a filter.