1 Reply Latest reply: Jun 10, 2013 10:25 AM by user6385671 RSS

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

    user6385671
      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