Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Determine if number is odd or even

Status
Not open for further replies.
jewelzaro

jewelzaro

Programmer
Jan 26, 2005
6
US
I need to determine if a number is odd or even within the layout functions that are available.


I need to add a calculation > Choose Layout > Choose “RowNumber()” within the functions.

From there I’m stuck. Not sure if I need to do the calculation in a “conditional expression”

I have tried to use the mod() feature but it only works if you add a calculation and choose detail. The problem with detail is that the RowNumber() function is not there.


I hope I made sense, any help would be great.
 
Status
Not open for further replies.

Similar threads

NicolaTesla1
  • Locked
  • Question
Hi, Anyone has ever had issues w
Replies
0
Views
257
NicolaTesla1
NicolaTesla1
kvenkata
  • Locked
  • Question
Forcing subquery in main query filter as optional even when data exists
Replies
0
Views
130
kvenkata
kvenkata
laurenbattaglia
  • Locked
  • Question
SQL Distinct Count of Order Numbers
Replies
0
Views
160
laurenbattaglia
laurenbattaglia
vignesvar
  • Locked
  • Question
List table report is not display when run the report using cognos connection?
Replies
0
Views
106
vignesvar
vignesvar
misscognos
  • Locked
  • Question
Order of inner and outer joins
Replies
1
Views
183
misscognos
misscognos

Part and Inventory Search

Sponsor

Back
Top