RowIndex() odd(?) behaviour

[system]

Hi All,

i have a question regarding RowIndex() function. When i add it to a table, it gets stretched.
For example i have a table where i get months from create date - MonthNumberOfYear([Create Date])
it displays values from 1 to 12. Now if i put RowIndex() in another collum in this table i get it stretched to 500000 rows… why it doesnt simply display values 1-12? (or 0-11)

---

Iscario (BOB member since 2012-09-03)

[system]

You’re confusing rowindex() with Linenumber().

Rowindex() returns the row from the database, e.g. the source data.

Use linenumber() if you want the line in a report block.

HTH

NMG

---

mcnelson (BOB member since 2008-10-09)

[system]

… ok thx.

There is no mentioning about this in either Webi or Documentation…

Thansk once again

---

Iscario (BOB member since 2012-09-03)

[system]

It’s in the “Web Intelligence Formulas, Functions & Calculations” document, but it’s a bit opaque:

RowIndex
Description
Returns the number of a row
Function Group
Misc
Syntax
integer RowIndex()

Notes
• Row numbering starts at 0.
• RowIndex returns #MULTIVALUE when placed in a table header or footer.
Examples

RowIndex returns 0 when it appears on the first row of a table.

This topic addresses the difference between Rowindex and Linenumber a bit better:

120×120 10.4 KB

Hi We have a table, in which we want to display the row number as a first column in a table. Tried using LineNumber() and rowindex() functions, but didn’t help. Appreciate your inputs. Thanks Ganesh gan_j (BOB member since 2007-02-19)

HTH

NMG

---

mcnelson (BOB member since 2008-10-09)