urgent help required in set analysis expression..?

[vishalgoud]

Hi Team ,

we have to restrict every chart to avoid the RG Group of MT...

so am adding the below set condistion in all the expressions to avoid it, but am in confusion how to add the same in below expression,

please help me.

=SUM(SMSVolume) / SUM(total <Month> SMSVolume)  

How to add below set condition in above expression please help me... Thank you.
{<RG_GROUP =- {"MT *"}>}

in numerator we can add easily but denominator part am getting confused....

[vishalgoud]

num(MAX(
aggr(sum({<Month={"$(vLastMonth)"},REVENUE_GROUP  -= {"MT *"}>}DataVolume),MSISDN)
),'#,##0')

i just changed the underliened part , i kept '- ' sign in front of = instead of keeping it after the equal sign... hope it will not change the meaning of my expression...

[vishsaggi]

You can find the difference of using -= and =- in the below link very well explained by HIC.

Excluding values in Set Analysis

I believe in your scenario, you should be using -= to exclude the values that starts with MT *. Hope this explains all.

[Anil_Babu_Samineni]

I didn't see any wrong in your expression?