Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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]))" ) )
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]))" ) )