CRM On Demand - Reports and Dashboards (MOSC)

MOSC Banner

use the saw function in results column to display a value of the comparison rows

edited Apr 18, 2016 5:01AM in CRM On Demand - Reports and Dashboards (MOSC) 2 commentsAnswered

I have a combined analysis report that shows the max of 2 records for each company.

Both rows will show a date field and a created by field

I want to compare the two date fields for that company to get the max date and then show the created by person in both records.  I have the function to get the max date showing properly.

Example

Company Name          Comparison Date          Created by     Column to show the max date: max(saw_1 by saw_0))            Column to show the Created by person of the max date??

Company ABC               1/1/2015                       User123                               3/1/2016                                                                                                     ??

Company ABC                3/1/2016                       User999                               3/1/2016                                                                                                    ??

Not sure what saw function to use (if possible) to show User999 on both rows.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center