set analysis with variable

[#1]

Hi,

The set analysis A is working correct.

I would like the same formel with variable as B1

The set analysis B2 isn't working correct. It come the value 0.

Can anybody help me for set analysis B2, why is wrongs.

A)Sum({$<[Calendar.Month]=, Calendar.Year=> * 1<[Calendar.MonthYear]=

{"$(='<='&Only(date(addmonths([Calendar.MonthYear],-1),'MMM-YYYY'))&'>'&Only(date(addmonths([Calendar.MonthYear],-13),'MMM-YYYY')))"} >}

Sales)

B1)

Varstartdate =(date(addmonths([Calendar.MonthYear],-1),'MMM-YYYY' ))

VarEnddate =(date(addmonths([Calendar.MonthYear],-13),'MMM-YYYY' ))

Varstartdate and VarEnddate display correct date.

B2)

sum({$<[Calendar.Month]=, Calendar.Year => * 1<[Calendar.MonthYear]=

{'>=$Only(#Varstartdate) <= $Only(#VarEnddate)'} >} Sales)

Thanks

[Anonymous]

Hi,

Without seeing the data it is hard to say..... try double quotes around your variables part, not single ones......

sum({$<[Calendar.Month]=, Calendar.Year => * 1<[Calendar.MonthYear]=

{">=$Only(#Varstartdate) <= $Only(#VarEnddate)"} >} Sales)

[#3]

Hi,

Thanks for your Help.

it doesen't work.

attached qvw

Thanks