Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
i added a field of num(Date) and i entered it in the set analysis and it worked.
tnx evryone!!
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.
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?
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))
its not working....
Hi,
you add date() in the variables:
VStartDate1--> =date(AddYears(min(Date),-1))
Regards
this is th file,
sheet 7 with text box of the variables and the set analysis problem.
tnx
I connot open the document. Denied access.
You try to replace $ with 1
can i do somthing to change it?