Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
My bad... can you try this
=Count({<[Session Name] = p($(='[' & SubField(GetCurrentSelections(), ':', 1) & ']'))>} [Session Name])
Hi Naresh ,
Try this ...
=Count({<[Session Name] = {'$(vCurrentSelection)'}>}[Session Name])
or
=Count({<[Session Name] = {='$(vCurrentSelection)'}>}[Session Name])
Mightbe helpful..
Thanks
PM
Not working.
Try this...
=Count({<[Session Name] = {"$(vCurrentSelection)"}>}[Session Name])
Might be Helpful..
Thanks
PM
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])
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
yes, have '=' sign before variable.
Try this..
=Count({<[Session Name] = {'"=$(vCurrentSelection)"'}>}[Session Name])
Regards
PM
try this too
Try this..
=Count({<[Session Name] = {'$(=vCurrentSelection)'}>}[Session Name])
still the same. I am getting the value '0'.
Thanks,
Naresh