Drill down group inside Aggr function ?

b_garside — Wed, 14 May 2014 13:45:08 GMT

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.

Re: Drill down group inside Aggr function ?

Anonymous — Wed, 14 May 2014 14:03:01 GMT

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]))" ) )