Need to get latest record - Page 2 — Oracle Analytics

Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Need to get latest record

Received Response
223
Views
14
Comments
2»

Answers

  • Jack
    Jack Rank 4 - Community Specialist

    this is also not brigning expected results, an other go

  • SriniVEERAVALLI
    SriniVEERAVALLI Rank 6 - Analytics Lead

    what you tried!!

  • Jack
    Jack Rank 4 - Community Specialist

    i tried

    C2 = MAX(C2 BY C1)

    i am getting max date, but missing record if C2 is null

    i am not getting c2 when null

    need to get max if C2 is not null, if c2 is null i need that record too

    please help

  • Jack
    Jack Rank 4 - Community Specialist

    issue resolved, thank you

    for your help