Call of variable contains set ananysis not possible in the chart

[#1]

Hello Community,

I tried to call a variable that contains set analysis statement but it is not possible. The set analysis statement contains itself some variables as follows:

sum( {1 <[dimension]={">=$(vVarable1)<=$(vVariable2)"}> } SALES)

This statement properly works in the chart. But if I set a new variable (under the settings -> Variable list) and add my statement as explained above and add the new variable to my chart (tab: formula), the value in the chart is empty. I don''t know why?

Thank you for any clue/proposal.

Best regards

[rubenmarin]

Hi Wahid, can you try to start your variable definition with an equal sign, ie:

=Sum(...)

[jonathandienst]

Hi

Please provide a model illustrating the problem and more details about the data model, how the variables are defined, the statement that works properly and the statement that does not work. Without at least part of this information I would only be guessing at the problem.

Jonathan

[chrislofthouse · Accepted solution]

Try:

sum( {1 <[dimension]={">=$(=$(vVarable1))<=$(=$(vVariable2))"}> } SALES)

[#5]

Thank you very much for your support. Meanwhile I found my problem by missing the second equal sign as Christother explained and it work:-)

@Ruben: this is not necessary to start a statement by a =. The interpreter does that.

Thank you all .again