Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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))
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))
Thanks for your help! It worked.