| begginer question [message #268739] |
Wed, 19 September 2007 09:29  |
eur6lts
Messages: 4
Registered: August 2007
|
Junior Member |
|
|
hi,
i have a table for eg:
name, gender, sallery, age
i need to show all records, and in culomn sallery i need to show details only for women (for e.g.) and a calculation for the man.
how should i do it on the discoverer?
thanks
|
|
|
|
| Re: begginer question [message #269755 is a reply to message #268739] |
Mon, 24 September 2007 07:36  |
skooman
Messages: 913
Registered: March 2005
Location: Netherlands
|
Senior Member |
|
|
Start Administrator, create an EUL, create a new Business Area, create a new folder from that table.
Start a user front end of discoverer (plus or desktop), create a new workbook, select all columns except the salary, create a calculation like:
CASE WHEN gender = F THEN salary WHEN gender = M THEN <you_calculation> ELSE null END; |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
