Business Objects - How to create S.No variable which starts from 1 ?

GeekInterview.com > Interview Questions > Data Warehousing > Business Objects

Go To First | Previous Question | Next Question

Business Objects | Question 228 of 233

How to create S.No variable which starts from 1 ?

I am trying to create S.No. column for a report by writing this formulae
=RowIndex() Where (="2002")But is generating S.No starting from 0 (not from 1).

Total Answers and Comments: 4

Last Update: June 27, 2008 Asked by: newinbo

Sponsored Links

Best Rated Answer

—

No best answer available. Please pick the good answer available or submit your answer.

April 25, 2008 07:29:27

krvikramraju

Member Since: April 2008 Contribution: 2

RE: How to create S.No variable which starts from 1 ?

Could you use =LineNumber() - 1

Is this answer useful? Yes | No

April 30, 2008 08:36:31

newinbo

Member Since: April 2008 Contribution: 8

RE: How to create S.No variable which starts from 1 ?

Thanks for your reply but it did not work by your way. Instead it worked by this way

=RowIndex()+1

(In Deskotop Intelligence).

Is this answer useful? Yes | No

May 24, 2008 08:01:02

krmuthu1510

Member Since: May 2008 Contribution: 1

RE: How to create S.No variable which starts from 1 ?

If you use the formula like =RowIndex()+1 then it will start from 1;

Is this answer useful? Yes | No

June 27, 2008 06:11:33

sekhar_ygr

Member Since: June 2008 Contribution: 0

RE: How to create S.No variable which starts from 1 ?

Create a new variable in report.

=RunningCount( Body ; Row ).

Is this answer useful? Yes | No

Go To Top