Home » Developer & Programmer » Reports & Discoverer » A tricky little one (re: discoverer)
A tricky little one (re: discoverer) [message #216575] Mon, 29 January 2007 08:41 Go to next message
Messages: 7
Registered: October 2006
Junior Member
Hello all again.

A tricky one for someone to shed some light on..

I have been requested to dig out some info on personnel pay and over time etc;

I use discoverer Plus 4i
someone wants to know total gross pay,overtime pay and overtime pay as a % of total gross.

Now, to obtain total gross, i have to bring back everything that is an allowance and sum it up.

however, within this allowance set, overtime is a sub set (distinct allowance code)
so to get the total gross i request all allowances, straight forward enough.
but, to get the o/t i need to specify a different condition which overwrites the gross pay one.

i can get both values by having seperate sheets and individual conditions for them, but how can I marry these together without conflicting on the allowance condition?
Tks in advance,
Re: A tricky little one (re: discoverer) [message #216697 is a reply to message #216575] Tue, 30 January 2007 00:44 Go to previous message
Messages: 913
Registered: March 2005
Location: Netherlands
Senior Member
Sounds like you need to use a CASE WHEN statement. To be sure, please post some sample data and an example of what you did so far.
Previous Topic: search on report
Next Topic: Invoic Printing Report issue in Oracle Applications
Goto Forum:

Current Time: Fri Jul 21 18:07:15 CDT 2017

Total time taken to generate the page: 0.20924 seconds