set analysis with variable

[adiarnon]

i have a problem with my expresion:

Sum({$<Year=,Month=,  Date={">=$(VStartDate1)<$(VEndDate1)"}>}Complain)

VStartDate1-->  =(AddYears(min(Date),-1))

VEndDate1--> =(AddYears(max(Date),-1))

why its not working (giving the wrong number)

maybe i need to take off the '='

tnx

[antoniotiman]

sum({1<.....,Date={.....

[adiarnon]

not working....

i think i try every possible syntax

[sushil353]

Hi,

Make sure that your Date field and the calculated variable format is same...

HTH,

Sushil

[antoniotiman]

my

sum({1<Pdv=P(Pdv),NData={"<=$(maxdata)>=$(mindata)"}>} sales)

[adiarnon · Accepted solution]

i added a field of num(Date) and i entered it in the set analysis and it worked.

tnx evryone!!