Help on viewing a related record field captured using aggregate records function

Help on viewing a related record field captured using aggregate records function

I wonder if anyone can help me please?

I'm relatively new to Creator and i'm struggling to find a way to do the following:

Using the syntax below, I can capture the appropriate value for the "Date_Worked_1" field,



but i'm stuck when it comes to returning the value from another field in the same record that this returns.

  1. Suggested_Date = jobs[Allocation == "AVAILABLE"].minimum(Date_Worked_1) ;



What i'm aiming for it to return the value for a field called "Hours_Worked_1" from the same record that the above syntax identifies.

If anyone can assist I would be most grateful.

Regards

Stuart