variable ?

[#1]

Hi All,

Can anybody tell me how to use more than one variable in set expression?

I have a variable => Vperiod  ->  =getfieldselection(PERIOD)

And I want to use it in expression  while they are more than one period in Vperiod :  (1,2,3,4,5,6,7,...)

expression is   =sum ( {$(=PERIOD=??????

Thanks

[cesaraccardi]

Hi,

You can use like this: sum({$<PERIOD={$(Vperiod)}>} Values)

Regards,

Cesar

[#3]

Thanks for reply,

It's good when you have one variable but withmore than one not working...

like 1,2,3,4,...

Any more idea?

[cesaraccardi]

I dont know if I understand... You have one variable with multiple values or more than one variable with multiple values?

[#5]

Here is the case:

I have period you which might be a single selection or multiple seceltion.

so if I select ie: period 1 , my getfiledselection returns 1 and in the set analysis it works, but if I select 1 & 2  in getfieldselection it returns 1,2 and in set analysis it goes crazy because it does not  work with 1,2 .

Is it clear?

Thanks

[cesaraccardi]

Ok... please notice that I put the variable inside the set without the ' around it. And this works if you define your variable with =GetFieldSelections(Period) otherwise the entire set of values will be treated as a single value and the expression wont work.

[MayilVahanan]

Hi

     Check this,

     Edit:

     Cesar Accardi Jr suggestion work.. Sorry Cesar Accardi Jr, i didn't see your post..

     Hope it helps

[cesaraccardi · Accepted solution]

Yes, thats exaclty what I suggested... using the variable without '

Edit: No problem, Mayil.

[#9]

Thanks Cesar,

Can you please tell me how to add "only" to this function?

[cesaraccardi]

Sure, using the function only:

sum({$<PERIOD={'$(=Only(Period))'}>} Values)

Note that this function will works if you have only 1 possible value for Period.