This discussion is archived
1 Reply Latest reply: Jun 10, 2013 8:25 AM by user18145 RSS

How to correctly use MAX or MAX..KEEP in Discoverer Desktop conditions

user18145 Newbie
Currently Being Moderated
I have been doing some research on trying to get a report in Discoverer that would give the latest Salary Change for the Salary History Table. We have a report where we would like to get the latest Salary for an Employee from the Salary History Table. We have a report on Discoverer that lists all of the Salary Changes. We want to get the latest change as of a certain date as well. I have read and tested using the MAX...KEEP sql statements. These do work and I get the resulsts in SQL that I want. However in Discoverer where would I place the sql MAX statement. I tried placing the statement in the conditions but it did not work and I got all the Salaries.

Thanks for any assistance that can be provided.
Kim

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points