rowindex

system · May 13, 2009, 8:41pm

Hey guys i got a question…i want to use row index to return 1-9 and for the 10th row it should say ‘>10’, really confused as to how i would make this happen…any help would be appreciated. thanks

showt2 (BOB member since 2009-05-11)

system · May 13, 2009, 9:19pm

Use an If-Then-Else variable.

=If(RowIndex()=1;1;If(RowIndex()=2;2;If(RowIndex()=3;3))) . . . etc.

MichaelWelter (BOB member since 2002-08-08)

system · May 13, 2009, 9:22pm

thats what i was trying but for the 10th row i need it to show ‘>10’ as a string and that can’t happen because a rowindex is a number field. thanks

showt2 (BOB member since 2009-05-11)

system · May 13, 2009, 9:33pm

Ahh, good point. Then you’ll need to modify it like this:

=If(RowIndex()=1;“1”;If(RowIndex()=2;“2”;If(RowIndex()=3;“3”))) . . . etc.

MichaelWelter (BOB member since 2002-08-08)

system · May 14, 2009, 3:00am

Simpler version example: =If(RowIndex()>=3;">=3";RowIndex()+"")

vigi_guna (BOB member since 2008-07-09)

system · May 14, 2009, 5:30am

Try the following
create variable
eg A=FormatNumber(Rownindex();“00”)

NOw create another variable
B =If(A=“10”;">10";A)

Please let me know if it works

DoSTh (BOB member since 2007-05-31)

system · May 14, 2009, 3:15pm

Hey thanks guys that was great help from all of you, i tried all of them and finally got it the way i wanted after i used Dominic Savio Thomas’s suggestion…however i see multiple values for >10 i just only want 1 entry saying the rest are >10…any suggestions? thanks.

showt2 (BOB member since 2009-05-11)

system · May 14, 2009, 3:36pm

any way to group the ‘>10’ values together? thanks.

showt2 (BOB member since 2009-05-11)

system · May 14, 2009, 4:09pm

Please do not bump your post until at least one business day has passed.

Do you have other dimensions in the table that are causing your measures to not aggregate?

MichaelWelter (BOB member since 2002-08-08)

system · May 14, 2009, 4:14pm

Hey, i appologize for the repeat post i was just trying to make it a bit more clear, but yea my rowindex is currently going with a order date column, could that be the issue? thanks

showt2 (BOB member since 2009-05-11)

system · May 14, 2009, 4:17pm

Yes. You’re measure will aggregate by whatever dimensions are in the table.

MichaelWelter (BOB member since 2002-08-08)

system · May 14, 2009, 4:22pm

Ah i see, well this is what im trying to achieve, i have a variable which gets the difference b/w order date and ship date and i want it to say if the difference is 1 day the result should show up in row 1 and if its 2 days the aggregate result should show up in row 2, any help towards a possible solution would be appreciated thanks.

showt2 (BOB member since 2009-05-11)