formula not working when put in a table

[samuel_brierley]

hi all,

i have the below formula (its a length one) that works fine in a text box and with a single date filtered but when i paste it into a chart with date as the dimension it nulls out. if i filter to one day the formula works in the table but obviously defeats the point..

thanks for any help.

num

((10-Sum(Aggr( if( ArbitrationInput.Group.rQo = only( {$< [/rec/parameter] = {'rMin'},[/#text] = {'CommonParameters'},[Config] = {Live}>}[/rec/parameter/curval]) and
ArbitrationInput.Group.rOOk < only( {$< [/rec/parameter] = {'rMax'},[/#text] = {'CommonParameters'},[Config] = {Live}>}[/rec/parameter/curval]) and
below(ArbitrationInput.Group.rQo,1,1) > only( {$< [/rec/parameter] = {'rMin'},[/#text] = {'CommonParameters'},[Config] = {Live}>}[/rec/parameter/curval]), 1,'')
,Time))
/( sum(aggr(if(ArbitrationInput.Group.rOOk < 950,1,''),Time))/60)/1.5),'##')

[robert_mika]

Could you attached your file?

[rubenmarin · Accepted solution]

Hi Samuel, you can try to add Date to the aggr function:

((10-Sum(Aggr( if( ArbitrationInput.Group.rQo = only( {$< [/rec/parameter] = {'rMin'},[/#text] = {'CommonParameters'},[Config] = {Live}>}[/rec/parameter/curval]) and
ArbitrationInput.Group.rOOk < only( {$< [/rec/parameter] = {'rMax'},[/#text] = {'CommonParameters'},[Config] = {Live}>}[/rec/parameter/curval]) and
below(ArbitrationInput.Group.rQo,1,1) > only( {$< [/rec/parameter] = {'rMin'},[/#text] = {'CommonParameters'},[Config] = {Live}>}[/rec/parameter/curval]), 1,'')
, Date,Time))
/( sum(aggr(if(ArbitrationInput.Group.rOOk < 950,1,''), Date,Time))/60)/1.5),'##')

[samuel_brierley]

You absolute beaut!!! so obvious now i just assumed adding it into the dimension would do this.

thanks