Set analysis in Average Aggr Sum function (Select Not In) not working.

[Marcushenriquesk]

 So I have a avg aggr sum function on one of my tables which is shown below:

=avg(aggr(Sum({<[TEST_ID]-={'>=90000<=99999'},[PANEL_ID]-={'>=30000<=39999'}>}Interval(RUN_DATE_TIME-RECEIVED_DATE_TIME))*24 ,ACC_ID))

The purpose of this function is to select the average interval between two dates per 'ACC_ID.' The set analysis is used to filter out ranges for two fields; 'PANEL_ID' and 'TEST_ID' as show per the '-='. However it's not working, I'm not sure if the syntax I used for the set analysis is not proper or... But, with this function in place and when I create a selection for panel id or test id within the ranges there is still data populating. 

[Lisa_P]

For ranges or wildcards you need double quotes inside curly brackets ..

=avg(aggr(Sum({<[TEST_ID]-={">=90000<=99999"},[PANEL_ID]-={">=30000<=39999"}>}Interval(RUN_DATE_TIME-RECEIVED_DATE_TIME))*24 ,ACC_ID))