need to get the associated record in max column

  • 0
  • 1
  • Question
  • Updated 5 months ago
  • In Progress
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
Photo of Pushpakumar Gnanadurai

Posted 5 months ago

  • 0
  • 1
Photo of Chris

Chris, Champion

  • 4,390 Points 4k badge 2x thumb

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
Photo of Chris

Chris, Champion

  • 4,390 Points 4k badge 2x thumb

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
Photo of Chris

Chris, Champion

  • 4,390 Points 4k badge 2x thumb

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.

(Edited)