Home » Developer & Programmer » Reports & Discoverer » begginer question
begginer question [message #268739] Wed, 19 September 2007 09:29 Go to next message
Messages: 4
Registered: August 2007
Junior Member
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?

Re: begginer question [message #269755 is a reply to message #268739] Mon, 24 September 2007 07:36 Go to previous message
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;
Previous Topic: Hierarchical tree denormalizing
Next Topic: How to set org context in discoverer plus
Goto Forum:

Current Time: Sun Jul 23 06:03:34 CDT 2017

Total time taken to generate the page: 0.09212 seconds