topic Re: Nested Set Analysis No Aggregation in App Development

Nested Set Analysis No Aggregation

krisslax — Wed, 01 May 2024 08:35:03 GMT

Hi, this has been driving me nuts and wondered if anyone would be able to help.

So I have 2 tables, the first is in a table chart on a sheet, and I need to retrieve 2 fields from the 2nd one using set analysis:

In the first table for Analysis 1, I have the following at it works great to retrieve the max date value:

=MAX( {$<[Field 4] = {'AAA'}>} DATE( [Field 5], 'dd-MMM-yyyy'))

In Analysis 2, I need the corresponding Field 6 that matches the Max Date.

My latest attempt was to use this as a nested set analysis without aggregation, but it returns blanks for all records:

ONLY( {$< [Field 5] = {"MAX( {$<[Field 4] = {'AAA'}>} DATE( [Field 5], 'dd-MMM-yyyy'))"}>} [Field 6])

BrunPierre — Wed, 01 May 2024 08:53:12 GMT

Try

ONLY( {$< [Field 5] ={"$(=MAX({$<[Field 4] = {'AAA'}>} DATE( [Field 5], 'dd-MMM-yyyy')))"}>} [Field 6])

krisslax — Wed, 01 May 2024 10:04:35 GMT

Hi, thank you for the reply, have tried that and it's the same Null value in the field I'm afraid.

BrunPierre — Wed, 01 May 2024 11:20:20 GMT

Like this?

=Only(If([Field 5]= Max({<[Field 4]={"AAA"}>}TOTAL [Field 5]), [Field 6]))