Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everybody,
I do have a problem with a set analyse.
I have two variables, var_from and var_to. (var_from = 10 ; var_to=20). I need to calculate the value of my variable between var_from and var_to and a tried it like this: {<VALUE = {">=$(Var_from) <=$(Var_to)”}>}, but it doesn't work.
Has anyone an idea how to do it?
Cheers Ines
Hi,
Your expression seems correct or you can try this way of expression
Ex:-
Sum({< VALUE = {'>=$(var_from) <=$(var_to)'} >} MetrcFieldHere )
Or
Count({< VALUE = {'>=$(var_from) <=$(var_to)'} >} MetrcFieldHere)
Regards
Anand
Hi,
See this simple example
LOAD
IterNo() as VALUE,
Rand() * 100 as Amt
AutoGenerate 1 While IterNo() <= 100;
And in chart use
Dim:- VALUE
Expre:-
sum({< VALUE = {">=$(var_from) <=$(var_to)"} >} Amt)
Regards
Anand
Hi Anand,
thanks for qour quick reply. It works perfect for me.
Cheers Ines