Need help to resolve the set analysis issue

[alknirmal1]

Hi All,

I have a variable declared in the variable overview tab.

varQuarter1 = $(varReportYear)&'-Q1'

where varReportYear is another variable which is set based on a selection from the list box.

I need to use the variable varQuarter1  inside a set analysis expression..

Expression :    Sum(Total {<DateYearQuarter={"$(=varQuarter1)"}>}AdjNOI)

This expression in set analysis is not giving the correct result.. When I hard code a value for varQuarter1 ,its gives me correct result.

Sum(Total {<DateYearQuarter={'2014-Q1'}>}AdjNOI)  -- This works fine.

I checked the variables varReportYear,varQuarter1  and both are returning correct values.

Can anyone please help me how to use this variable correctly in setanalysis .

Thanks

Nirmal.

[alknirmal1]

Thanks a lot Colin.. It worked fine ..

first time it was my bad .... i made a small mistake and it didn't work.

Now its working perfectly..

Thank you everyone for helping me on this.