Skip to main content
Question

need to get the associated record in max column

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
    This topic has been closed for replies.

    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?

    Hi .. Yes.. i have created a summary field. But i need the "phase" column value of that particular value.

    Thanks

    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.

    Hi Chris, I need the phase for the maximum date.

    A associated column for the maximum value.

    Thanks
    Pushpakumar

    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.

    Terms & ConditionsAccessibility statement