E10.0 - SubQuery return maximum transaction date (Bin Ex.)

Any calculated field that uses aggregates (like MAX(), MIN(), COUNT(), SUM(), etc…) must have it’s GroupBy box unchecked.

If you need to group by that calculated field, you need to add another subquery layer.