Variable with multiple values

[lionking15]

Hi Guys,

Used an expression

sum({<Measure_Code={'$(_vToggleExp2)'}>}VALUE)/1000000

Previously:_vToggleExp2=1

Currently: i want to pass multiple values _vToggleExp2=1,3(which is  not working),I can't change the expression,i want to do change at variable level.

Kindly suggest.

Regards,

Giridhar Randive

[Quy_Nguyen]

Try setting your variable like: _vToggleExp2= 1' , '3

[lionking15]

Did't worked

[kaushiknsolanki]

Try this.

sum({<Measure_Code={"$( =Replace(_vToggleExp2,',','","') )"}>}VALUE)/1000000

Assuming _vToggleExp2 contains value as 1,3

Regards,

Kaushik Solanki

[lionking15]

I can't make changes at expression level(Some Constraints),Cant make a change only at variable level.

[lionking15 · Accepted solution]

'1'&chr(39)&','&chr(39)&'3'

[Quy_Nguyen]

Are you sure your expression is: sum({<Measure_Code={'$(_vToggleExp2)'}>}VALUE)/1000000 ?