Discussions

Expand all | Collapse all

need to get the associated record in max column

  • 1.  need to get the associated record in max column

    Posted 07-25-2018 10:42
    Hi Team,

    Can you please let me know how to fetch a associated record in a maximum summary field

    for example,
    Phase Imp Date
    1         23-Jun-18
    2         23-Jun-19
    3         22-Jun-20  
    4         22-Jun-21  
    5         22-Jun-22  

    I want to calculate the summary field max(imp date) and its associated phase number , in this case 22 jun 22 and 5

    is there a way to capture 5?

    PLease help

    Thanks


  • 2.  RE: need to get the associated record in max column

    Posted 07-25-2018 13:51

    Hello

    In the parent table, create a summary field that captures Max Date. If you do not have a parent table, you may have to create one in order to find the max date. Could you not filter your report to sort in descending order by that date?



  • 3.  RE: need to get the associated record in max column

    Posted 07-25-2018 13:57
    Hi .. Yes.. i have created a summary field. But i need the "phase" column value of that particular value.

    Thanks


  • 4.  RE: need to get the associated record in max column

    Posted 07-25-2018 15:36

    If you want to find the maximum phase, you'd make another max summary field based on the max date summary field. See configuration for new summary field below.

    ===========================================================

    Field to summarize: Choose a field from the "table name" table -

    [Phase] << field to summarize

    Where the following is true:

    [Date Field] = the value in the field [Max Date Field] <your max date summary field.

    Function: Maximum

    ============================================================

    See how that works for you.



  • 5.  RE: need to get the associated record in max column

    Posted 07-25-2018 15:53
    Hi Chris, I need the phase for the maximum date.

    A associated column for the maximum value.

    Thanks
    Pushpakumar


  • 6.  RE: need to get the associated record in max column

    Posted 07-25-2018 17:04

    In your [max date] summary field, go into the properties and add a condition to "only summarize where the following is true". Select your [phase field] is equal to 5.

    You will derive the highest date where phase is 5.