Drill down group inside Aggr function ?

[b_garside]

Trying to get this Drill down group to work inside my Aggr function.I'm using it in a linear gauge for Max parameter.

Max( Aggr( Sum([Average Total Payments]), $(=GetCurrentField([State-HRR])) ) )

I get a blank or null value result. Both in a text box and in the table.

[Anonymous · Accepted solution]

Works for me.

There could be a problem with the spaces in field names.  Try to change a little:

Max( Aggr( Sum([Average Total Payments]), "$(=GetCurrentField([State-HRR]))" ) )