using MAX in script to get one record per client

[Anonymous]

Hi,

I want to get the max of several fields for a client but also need to add other fields for the same client into a single record.

The uploaded example has color codes to show which values and fields I need in the final record for a client.

Thanks.

[bgerchikov · Accepted solution]

Hi Elsabe,

Please review attached.

Hope it will help.

[Anonymous]

This is what I need. Thank you!