AnsweredAssumed Answered

aggregate MIN function not working in calculation

Question asked by DennisFlight on Oct 24, 2014
Latest reply on Oct 24, 2014 by philmodjunk

Title

aggregate MIN function not working in calculation

Post

I have a portal on table 1 showing related records from table 2

Table 2 has two fields field 1(Number field with numbers) and field 2(text field with names)

I have a field on table 1 that is a calculation. I would like the calculation to find the lowest number in Table2:Field1  but to display the corresponding name from Table2:field2

I tried everything i can think of. I have no trouble getting the lowest # using the MIN function.

Thanks

 

 

Outcomes