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

[swuehl]

What do you mean with 'wrong number', could you post a small sample application and your requested results?

In general, I would start with checking if the dollar sign expanded variables are expanded correct and in the required format (format of field Date). Paste your expression in a straight table (no dimension required), then hover over the expression label, you should see the expression with variables expanded.

[adiarnon]

hi,

if  in the variable i put VStartDate1-->(AddYears(min(Date),-1)) without = before

and im adding a text box with =$(VStartDate1) i get 01/01/2014

and if in the variable i put VStartDate1-->=(AddYears(min(Date),-1)) with  = before

and im adding a text box with =$(VStartDate1) i get 0.088.....

witch i should choose and how can i put in the setanalysis?

[swuehl]

Try an equal sign before your variable definition, then enclose the variable expansion in single quotes:

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

or instead, use the num() function in your variable definitions (also with equal sign before the expression):

=num(AddYears(min(Date),-1))

[adiarnon]

its not working....

[antoniotiman]

Hi,

you add date() in the variables:

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

Regards

[adiarnon]

this is th file,

sheet 7 with text box of the variables and the set analysis problem.

tnx

[antoniotiman]

I connot open the document. Denied access.

[antoniotiman]

You try to replace $ with 1

[adiarnon]

can i do somthing to change it?