Variable expressions in set analysis

[#1]

Hi ;

I have 2 variables (vMaxWeek) and (vMaxWeek_3). The variables are correct are pulling values.

I then wrote this set analysis expression:

=sum(   {<[WeekNumber] = {>=$(vMaxWeek) <= $(vMaxWeek_3)}>}      loadingDuration).

The result is not correct.

Please assist.

[#2]

try to use ' ', something like:

=sum(   {<[WeekNumber] = {'>=$(vMaxWeek) <= $(vMaxWeek_3)'}>}      loadingDuration)

instead of

=sum(   {<[WeekNumber] = {>=$(vMaxWeek) <= $(vMaxWeek_3)}>}      loadingDuration)

for my example, it worked

[petter]

You must enclose the search in double-quotes like this:

=sum(  {<[WeekNumber] = {">=$(vMaxWeek) <= $(vMaxWeek_3)"}>}   loadingDuration)

[petter]

Furthermore the variables might have to be evaluated depending what is in them - constants or expressions.

So you might have to write:

=sum(   {<[WeekNumber] = {>=$(=vMaxWeek) <= $(=vMaxWeek_3)}>}      loadingDuration).