Trying to use a variable In Set Analysis

[narband2778]

Hello Everyone,

I have created a Variable in the Variables

vCurrentSelection =SubField(GetCurrentSelections(), ':',2)

and now I am trying to use the variable in Set analysis, but it is not working

=Count({<[Session  Name] = {"$(=vCurrentSelection)"}>}[Session  Name])

Can someone help me with this.

thanks in advance.

Naresh

[praveenkumar_ma]

Hi Naresh ,

Try this ...

=Count({<[Session  Name] = {'$(vCurrentSelection)'}>}[Session  Name])

or

=Count({<[Session  Name] = {='$(vCurrentSelection)'}>}[Session  Name])

Mightbe helpful..

Thanks

PM

[narband2778]

Not working.

[praveenkumar_ma]

Try this...

=Count({<[Session  Name] = {"$(vCurrentSelection)"}>}[Session  Name])

Might be Helpful..

Thanks

PM

[narband2778]

Not good Praveen. i am getting the result 0.

I am using the hard coded value then I am getting the count for below expression.

=Count({<[Session  Name] = {'XYZ'}>}[Session  Name])

[praveenkumar_ma]

Try this or Previous

=Count({<[Session  Name] = {"'=$(vCurrentSelection)'"}>}[Session  Name])

and in Variable Defination do you have '=' front of Defination

just for info..

this might helpful

Thanks

PM

[narband2778]

yes, have '=' sign before variable.

[praveenkumar_ma]

Try this..

=Count({<[Session  Name] = {'"=$(vCurrentSelection)"'}>}[Session  Name])

Regards

PM

[Chanty4u]

try this too

Try this..

=Count({<[Session  Name] = {'$(=vCurrentSelection)'}>}[Session  Name])

[narband2778]

still the same. I am getting the value '0'.

Thanks,

Naresh