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....

[fvelascog72]

Hi,

Maybe:

=SUM({<RG_GROUP =- {"MT *"}>}SMSVolume) / SUM(total <Month> {<RG_GROUP =- {"MT *"}>}SMSVolume)

Saludos

[Anil_Babu_Samineni]

Perhaps this?

=SUM({<RG_GROUP -= {"MT *"}>} SMSVolume) / SUM({<RG_GROUP -= {"MT *"}>} total <Month> SMSVolume)  

[vishalgoud]

Thanks for the Quick reply,

SUM(total <Month> {<RG_GROUP =- {"MT *"}>}SMSVolume) - in this denominator part is this indicates <Month>

even i tried the same and its not showing any expression error. but was just thinking we have to include this month in the set expression or what ..

earlier the expression was =SUM(SMSVolume) / SUM(total <Month> SMSVolume)   so what he is achieving from denominator part...

[vishalgoud]

thanks for the quick help Anil,

what is this part indicates  <Month> from the below expression.

=SUM({<RG_GROUP -= {"MT *"}>} SMSVolume) / SUM({<RG_GROUP -= {"MT *"}>} total <Month> SMSVolume)

[fvelascog72]

Hi,

Now i don´t understand your question.

Do you have a sample app to explain your request?

Saludos.

[Anil_Babu_Samineni]

SMSVolume will SUM the value of based on TOTAL Month field. For example

Data set is like below

Load * Inline [

Month, SMSVolume

Jan, 100

Jan, 200

Feb, 300

Feb, 100

];

And measure is this?

Sum(TOTAL <Month> SMSVolume) will return

result:

Jan, 300

Feb, 400

[vishsaggi]

This means you are aggregating Sum(SMSVolume) by Month. And the TOTAL qualifier here respects the current selections on Month field. If you do no select any it will sum the volume for all months.

[vishalgoud]

Thanks again , while am adding the same to other expression am getting an error in expression msg.

Can you please guide me what is worng in this below expression. it saying error in expression.

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

[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...