variable and set analysis

[#1]

HI all

I've a problem with variable and set analysis.

I've this expression : =sum( {$<ANNO = {$(=Only(ANNO))}>} EMESSO_P_GI )

because I have to use it in many analyzes, I would put the set analalysis formula in a variable then i created a variable

V_var=sum( {$<ANNO = {$(=Only(ANNO))}>} EMESSO_P_GI )

and then i used it in a colum table but it did not work.

the question is: is it possible  put in a variable  a whole set analysis expression??

thanks for your help

[sunny_talwar]

Couple of questions:

1. When you use the expression in a straight table does it give you your desired output?
2. Are you using V_var as the expression or $(V_var)? Try using $(V_var), if you are not.

the question is: is it possible  put in a variable  a whole set analysis expression??

To answer the above question -> Yes you can save a whole set analysis expression in a variable.

[swuehl]

It seems that you put the whole expression into a variable, not only the set analysis part.

You should be able to do both, but you may need to take care of the way you defined your variable:

The Magic of Variables

[maxgro]

yes it's possible

see attachment

[#5]

thanks for your help.

i tried  to use $var but it did not work. this is the new outcome:

V_EMESSO_P_GI is =sum( {$<ANNO = {$(=Only(ANNO))}>} EMESSO_P_GI )

AREA	2015	2014	208390661,80896
italy	829,201	42,966	0
england	3,382,028	41,259,523	0
austria	28,225	87,062	0
germany	93,376	1,861,027	0
	=sum( {$<ANNO = {$(=Only(ANNO))}>} EMESSO_P_GI )	=sum( {$<ANNO = {$(=Only(ANNO-1))}>} EMESSO_P_GI )	$(V_EMESSO_P_GI)

maybe it could be a var  scope issue, it seems that the Variable does not recognize the dimension level (Area).

i really appreciate your help

ciao

[#6 · Accepted solution]

the soluions was:

I was wrong variable's syntax

thanks for help

ciao