Max value of a sub-query

building reports desktopintelligence
4

I think that you should be able to do this in the subquery have you tried using the Calculation Operand ?
There are several threads about this for example https://bobj-board.org/t/248

Michele Pinti (BOB member since 2002-06-17)