Help with Set Analysis

[#1]

Hi,

Please can someone help me with below expression. I would like to ignore selection of GR month in below set analysis expression.
I tried using -
 Avg ({<GRMonth=>} aggr( Only({$<[MM_Exclude_Flag]= {0} >} MM_Total_Time),Delivery_Key))
It is giving same results when used without {<GRMonth=>} before aggr function as below.
 Avg (aggr( Only({$<[MM_Exclude_Flag]= {0} >} MM_Total_Time),Delivery_Key))
Please let me know the correct syntax.
Thanks in advance!

[swuehl · Accepted solution]

Try including your ignored field also into the inner set expresssion:

=Avg ({<GRMonth=>} aggr( Only({$<[MM_Exclude_Flag]= {0}, GRMonth= >} MM_Total_Time),Delivery_Key))

[#3]

Thanks for your help! It worked.