Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Couple of questions:
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.
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:
yes it's possible
see attachment
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
the soluions was:
I was wrong variable's syntax
thanks for help
ciao